fx =IFS(A1>=90,"A",A1>=80,"B",A1>=70,"C",TRUE,"F")ABCOrder #1042$1,250ApprovedOrder #1043$450ReviewOrder #1044$3,200Approved
🔀 Logic

IFS Formula for Logic

Check multiple conditions (cleaner than nested IF). Copy-paste ready for Excel, Google Sheets, and Airtable.

=IFS(A1>=90,"A",A1>=80,"B",A1>=70,"C",TRUE,"F")
When you need this: When you need to assign letter grades (A, B, C, F) based on test scores in A1 (90+ = A, 80–89 = B, etc.).

How it works

  1. 1Evaluate conditions in order (90, 80, 70).
  2. 2Return the value for the first true condition.
  3. 3TRUE as final condition acts as a fallback (catch-all).

Variations

IFS for performance tiers
=IFS(A1>=500000,"Executive",A1>=100000,"Manager",A1>=50000,"Senior",TRUE,"Junior")
IFS with OR conditions
=IFS(OR(A1="Premium",B1="VIP"),"Priority",TRUE,"Standard")

Related Formulas

IF — Return different values based on a conditionLogicIFERROR — Show a custom value instead of an errorLogicAND / OR — Check if multiple conditions are trueLogicCHOOSE — Return value based on index numberLogic

Need a formula that's not here?

Generate custom formula →