Excel Study · Module 3: Decisions with IF
Class 22IF with numbers: a bonus
Basics1:33 videoFree
IF can give back a calculation, not just a word. If a salesperson's sales reach their target, the bonus is 10 percent of the sales; if not, the bonus is 0. One formula, filled down for the whole team.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, B2 has a person's sales and C2 has their target. Write a formula for E2 that gives a bonus of 10% of the sales if the sales are at least the target, otherwise 0.
The answer that works
✓ checked in Excel=IF(B2>=C2, B2*0.1, 0)
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.