IFS

IFS checks conditions left to right and returns the result for the first one that is true, replacing long nested IF chains. Add TRUE as the final test for a catch-all. Available in Excel 2019/365 and Google Sheets.

Excel

=IFS(A2>=90, "A", A2>=80, "B", A2>=70, "C", TRUE, "F")

Google Sheets

=IFS(A2>=90, "A", A2>=80, "B", A2>=70, "C", TRUE, "F")

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1Each pair is a condition and the result if it is true.
2The first true condition wins.
3TRUE at the end acts as the "else" case.

Need a version for your data?

Try: “Grade A2: 90+ is A, 80+ is B, 70+ is C, otherwise F”

IF IFERROR SWITCH

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

IFS

Try it with your data

How it works

Related