IF with numeric output
BeginnerIn bonus-tracking sheets, you often need rules like: “Pay a bonus only if someone beats their target.” The IF function is perfect for this, and it can return numbers (not just text).
The IF function has three parts:
=IF(logical_test, value_if_true, value_if_false)
What you need to do
You have monthly sales and targets in columns B and C. In column D, you’ll calculate the bonus:
- If Sales > Target, bonus = 10% of Sales
- Otherwise, bonus = 0
Follow these steps:
- Click cell D2 (Ava’s Bonus).
- Write an IF formula that checks whether the sales in B2 is greater than the target in C2.
- If the condition is TRUE, return a number equal to 10% of the sales amount.
- If the condition is FALSE, return 0.
- Press Enter.
- Copy your formula down from D2 to D8.
Quick check: Cam is exactly on target (Sales equals Target), so Cam’s bonus should be 0.
Need some help?
Hint 1
Your logical_test should compare the Sales cell to the Target cell using a greater-than sign ( > ).
Hint 2
For the TRUE result, you need a calculation that returns 10% of sales (you can multiply the sales value by 10% or by 0.1).
Hint 3
Build the formula in D2 using B2 and C2 as the inputs, then fill the same pattern down to D8 so each row uses its own Sales/Target values.
IF with numeric output
BeginnerIn bonus-tracking sheets, you often need rules like: “Pay a bonus only if someone beats their target.” The IF function is perfect for this, and it can return numbers (not just text).
The IF function has three parts:
=IF(logical_test, value_if_true, value_if_false)
What you need to do
You have monthly sales and targets in columns B and C. In column D, you’ll calculate the bonus:
- If Sales > Target, bonus = 10% of Sales
- Otherwise, bonus = 0
Follow these steps:
- Click cell D2 (Ava’s Bonus).
- Write an IF formula that checks whether the sales in B2 is greater than the target in C2.
- If the condition is TRUE, return a number equal to 10% of the sales amount.
- If the condition is FALSE, return 0.
- Press Enter.
- Copy your formula down from D2 to D8.
Quick check: Cam is exactly on target (Sales equals Target), so Cam’s bonus should be 0.
Need some help?
Hint 1
Your logical_test should compare the Sales cell to the Target cell using a greater-than sign ( > ).
Hint 2
For the TRUE result, you need a calculation that returns 10% of sales (you can multiply the sales value by 10% or by 0.1).
Hint 3
Build the formula in D2 using B2 and C2 as the inputs, then fill the same pattern down to D8 so each row uses its own Sales/Target values.