ExcelFlux

IFS function

Check — whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

Logical · Excel 2019+

Where can you use it?

Teams building reports and business rules. Adapt the example’s decision rule when you need to test a condition or display different results based on it.

Scenario in the workbook

Order the thresholds from highest to lowest. The first true condition supplies the result.

A worked example from the workbook

RowA
6Value
795
875
960
Record 1
=IFS(A7>=90,"A",A7>=70,"B",TRUE,"C")

Expected resultA

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=IFS(5>8,"High",5>3,"Medium",TRUE,"Low")
Turkish Excel · tr-TR
=ÇOKEĞER(5>8;"High";5>3;"Medium";DOĞRU;"Low")

Expected result

“Medium”

Worked examples

Order the thresholds from highest to lowest. The first true condition supplies the result.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Value
7 95
8 75
9 60
Case Formula Expected result
Record 1 =IFS(A7>=90,"A",A7>=70,"B",TRUE,"C") A
Record 2 =IFS(A8>=90,"A",A8>=70,"B",TRUE,"C") B
Record 3 =IFS(A9>=90,"A",A9>=70,"B",TRUE,"C") C
Microsoft Excel reference