Simple IF statement
BeginnerIn sales reporting, it’s common to label results as “on target” or “off target”. The IF function helps you do that automatically based on a rule you define.
The IF function has three parts:
=IF(logical_test, value_if_true, value_if_false)
What you need to do
- Click cell D2 (the first cell under Status).
- Type an IF formula that checks whether the sales value in B2 meets or exceeds the target in C2.
- If the rep met the target, return On target. Otherwise, return Below target.
- Press Enter.
- Copy your formula down from D2 to D8 (you can drag the small square in the bottom-right corner of D2).
When you’re done, every rep should have a Status of either On target or Below target.
Need some help?
Hint 1
Your logical_test should be a comparison between the sales cell and the target cell (for example: sales is greater than or equal to target).
Hint 2
Because you want words as the result, your IF outputs must be in quotes, and the text must match exactly: "On target" and "Below target".
Hint 3
Start in D2 by comparing B2 to C2, then fill the same formula down to D8. One row has sales equal to target, and it should still be labeled On target.
Simple IF statement
BeginnerIn sales reporting, it’s common to label results as “on target” or “off target”. The IF function helps you do that automatically based on a rule you define.
The IF function has three parts:
=IF(logical_test, value_if_true, value_if_false)
What you need to do
- Click cell D2 (the first cell under Status).
- Type an IF formula that checks whether the sales value in B2 meets or exceeds the target in C2.
- If the rep met the target, return On target. Otherwise, return Below target.
- Press Enter.
- Copy your formula down from D2 to D8 (you can drag the small square in the bottom-right corner of D2).
When you’re done, every rep should have a Status of either On target or Below target.
Need some help?
Hint 1
Your logical_test should be a comparison between the sales cell and the target cell (for example: sales is greater than or equal to target).
Hint 2
Because you want words as the result, your IF outputs must be in quotes, and the text must match exactly: "On target" and "Below target".
Hint 3
Start in D2 by comparing B2 to C2, then fill the same formula down to D8. One row has sales equal to target, and it should still be labeled On target.