IF Function - Free Excel Practice Online

This free, interactive exercise teaches you IF Function in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Logical Functions track and works right in your browser - no Excel install, no download, and no signup.

Practising IF Function this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.

What you'll practice in this IF Function lesson

1. IF statements in Excel evaluate a condition and return one value if the condition is true and another value if the condition is false:=IF(condition, value_if_true, value_if_false)Type the following IF statement that returns the word "Rich" if the value in cell B3 is greater than $100,000 and otherwise returns "poor".=IF(B3>100000, "Rich", "Poor")Remember that in Excel, text goes inside quotation marks, but numbers do not.
2. What would the formula =IF(B3>100000, "Rich", "Poor") return?In other words, what is the result of the formula?
3. Each dog gets two scoops of food if it weighs greater than 30 lbs, and otherwise gets one scoop of food.Write an IF statement that returns the number of scoops Lilly gets.
4. What would =IF(B3>30, 2, 1) return?
5. If a dog's age is greater than or equal to 10, it gets 2 vaccinations, otherwise it gets 3.Write an IF statement to determine the number of vaccinations Fluffy gets.
6. What would =IF(B2>=12, 2, 3) return?
7. A movie theater charges $12 per ticket, but charges $8 for anyone age 65+.Write an IF statement to determine the price of Susan's ticket.
8. What would =IF(B5>=65, 8, 12) return?
9. What would =IF(B5>65, 8, 12) return?
10. What would =IF(B4>=65, 8, 12) return?

IF Function practice - FAQ