Conditional Logicintermediate
Evaluate multiple conditions with IFS
=IFS(A2>=10000,"Gold",A2>=5000,"Silver",A2>=1000,"Bronze",TRUE,"Standard")
Function reference
IFS in Excel & Google Sheets
IFS is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.
1 intermediateBuild a custom IFS formula →
When to use IFS
- Assign a discount tier based on order size, map a numeric score to a letter grade, or classify customers into segments by revenue band.
Worked examples (1)
Common errors with IFS
IFS returns
IFS has no built-in default. Add TRUE as the last condition with the fallback value — IFS(...,TRUE,"Default") — to prevent #N/A when no condition is met.
Wrong tier returned
IFS returns the result for the first TRUE condition. If conditions overlap, order them from highest threshold to lowest so the correct tier matches first.
Frequently asked questions
How many conditions can IFS evaluate?
IFS supports up to 127 condition-result pairs. In practice, more than 5–7 tiers suggest a lookup table may be a better approach.
Need a custom variation?
Describe your specific IFS problem and get a formula written for your exact data.
Open generator with IFS