Guides

IFS, SWITCH and CHOOSE: Cleaner Than Nested IF

By Ravindra Bagale, Excel & Data Analytics trainer · LinkedIn · Published: 6 October 2026 · Last updated: 6 October 2026

Rani's grade formula has four IFs inside each other and eight closing brackets. One missing bracket and nothing works. She rewrites it with IFS, maps branch codes to regions with SWITCH, and turns exam dates into financial-year quarters with CHOOSE.

IFS checks conditions in order and returns the value of the first TRUE one. SWITCH compares one value against a list of exact matches. CHOOSE returns the item at a given position (1, 2, 3...). IFS and SWITCH need Excel 2019 or later; CHOOSE works in every version.

Download the practice file (ifs-switch-choose.xlsx)

Excel file, 6 KB. It has the sample data used below. All numbers in this workbook are fictional teaching data, not real company figures.

=IFS(B2>=85,"A",B2>=70,"B",B2>=50,"C",B2>=40,"D",TRUE,"Fail")
=SWITCH(D2,"PUN","West","NSK","North","KOP","South","NGP","Vidarbha","SLP","South","Unknown")
=CHOOSE(MONTH(F2),"Q4","Q4","Q4","Q1","Q1","Q1","Q2","Q2","Q2","Q3","Q3","Q3")

Results on the practice data

IFS: first TRUE wins

Compare with the nested IF: =IF(B2>=85,"A",IF(B2>=70,"B",IF(B2>=50,"C",IF(B2>=40,"D","Fail")))). Same answer, but IFS needs no stack of brackets.

SWITCH: exact matches with a default

The regions here are a fictional company's sales zones. SWITCH looks at one value (the code) and returns the result paired with the matching code. Salman's code ABC is not in the list, so he gets the default Unknown. SWITCH cannot do ranges like >=70; use IFS or a lookup table for those.

CHOOSE: pick by position

MONTH(F2) gives 1 to 12. CHOOSE returns the 1st to 12th item from the list. Because the Indian financial year starts in April, months 1-3 (Jan-Mar) are Q4 and months 4-6 are Q1.

Other uses: =CHOOSE(WEEKDAY(A2),"Sun","Mon",...), or a scenario switch =CHOOSE(B1,low,mid,high) driven by a 1/2/3 drop-down.