BeginnerFormulas3 min10 points

Calculate achievement against target

The situation

Harbor Supply's regional managers are reviewed each quarter against a sales target. You have been asked to work out where each rep landed.

Calculate achievement against target — question sheet. Use the arrow keys to move between cells, Enter or F2 to edit, Escape to cancel, Control D to fill down from the cell above, and Control C and Control V to copy and paste.
Row number	A	B	C	D
1	Rep	Sales	Target	Achievement
2	Marcus Bell	$95,000	$100,000
3	Dana Whitfield	$120,000	$100,000
4	Alan Reyes	$80,000	$100,000
5	Priya Raman	$143,000	$130,000
6

Use IF to label each rep as meeting or missing their target.