IF practice exercises
Make a formula choose between two answers with IF: pass or fail, bonus or none, and nested IFs for more than two outcomes.
- 1Pass or fail with IFThe passing score is 50. In C2, use IF to show "Pass" when the score in B2 is 50 or more, and "Fail" otherwise.
- 2Calculate a bonus with IFPremiumSellers with sales over 1000 get a 10% bonus; everyone else gets 0. In C2, use IF to calculate the bonus for B2.
- 3Three outcomes with nested IFPremiumGrade the score in B2: 90 or more is "A", 70 or more is "B", anything lower is "C". In C2, put a second IF inside the first.
- 4Flag missing values with ISBLANKPremiumIn D2, show "Missing" when the hours in B2 are blank, and otherwise the pay, B2*C2. Use IF with ISBLANK.
- 5Compare two cells with IFPremiumIn D2, show "Over budget" if the amount spent in C2 is more than the budget in B2, and "OK" if not.