IFS Function - Free Excel Practice Online

This free, interactive exercise teaches you IFS 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 IFS 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 IFS Function lesson

1. The IFS function allows you to test multiple criteria and return a value corresponding with the FIRST true condition. Let's say employees get a $1,000 bonus if they close 5 or more deals, $500 if they close 3 or more deals, and $0 if they close fewer than 3 deals. The IFS function evaluates the criteria in order and returns the first true option. Try typing =IFS(B2>=5, 1000, B2>=3, 500, B2 to calculate John's bonus.
2. What would =IFS(B2>=5, 1000, B2>=3, 500, B2 return?
3. What would =IFS(B3>=5, 1000, B3>=3, 500, B3 return?
4. What would =IFS(B4>=5, 1000, B4>=3, 500, B4 return?
5. What would =IFS(B5>=5, 1000, B5>=3, 500, B5 return?
6. Write an IFS statement to determine what to pack when visiting Phoenix. If temperature is greater than or equal to 90, return "Tank Top". If temperature is greater than or equal to 70, return "T Shirt". If temperature is less than 70, return "Jacket".
7. What would =IFS(B2>=90, "Tank Top", B2>=70, "T Shirt", B2 return?
8. What would =IFS(B3>=90, "Tank Top", B3>=70, "T Shirt", B3 return?
9. What would =IFS(B4>=90, "Tank Top", B4>=70, "T Shirt", B4 return?
10. What would =IFS(B5>=90, "Tank Top", B5>=70, "T Shirt", B5 return?

IFS Function practice - FAQ