# IFS formula generator

> Describe what you need and get a IFS formula for Excel and Google Sheets, run on real data before you copy it. Plus 8 tested IFS examples.

Source: https://spreadsheetpractice.com/tools/formula-generator/ifs · Updated October 29, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

IFS checks a list of conditions in order and returns the value paired with the first one that is TRUE.

Describe the task at [IFS formula generator](https://spreadsheetpractice.com/tools/formula-generator/ifs) and get a IFS formula for Excel and Google Sheets, tested on real data.

## Tested IFS examples

### Calculate tiered commission with IF

`=B2*IFS(B2>=$E$4,$F$4,B2>=$E$3,$F$3,TRUE,$F$2)`

Excel. Result on the sample sheet: 6 rows (C2:C7). [See it and try it](https://spreadsheetpractice.com/formulas/tiered-commission-with-if)

### Assign letter grades with IF or IFS

`=IFS(B2>=90,"A",B2>=80,"B",B2>=70,"C",B2>=60,"D",TRUE,"F")`

Excel. Result on the sample sheet: 7 rows (C2:C8). [See it and try it](https://spreadsheetpractice.com/formulas/nested-if-grades)

### Group ages into ranges

`=IFS(B2<18,"Under 18",B2<35,"18-34",B2<55,"35-54",TRUE,"55+")`

Excel. Result on the sample sheet: 8 rows (C2:C9). [See it and try it](https://spreadsheetpractice.com/formulas/group-ages-into-ranges)

### Use IFS

`=IFS(B2<1,"Small",B2<5,"Medium",B2<20,"Large",TRUE,"Freight")`

Google Sheets. Result on the sample sheet: 8 rows (C2:C9). [See it and try it](https://spreadsheetpractice.com/formulas/use-ifs-for-several-conditions)

### Check if a date is later than another date

`=IF(C2="","Open",IF(C2>B2,"Late","On time"))`

Excel. Result on the sample sheet: 6 rows (D2:D7). [See it and try it](https://spreadsheetpractice.com/formulas/check-if-a-date-is-later-than-another-date)

### Flag dates that expire within 30 days

`=IF(C2<$F$1,"Expired",IF(C2-$F$1<=$F$2,"Expires soon","OK"))`

Excel. Result on the sample sheet: 6 rows (D2:D7). [See it and try it](https://spreadsheetpractice.com/formulas/flag-dates-expiring-within-30-days)

### Why does IFS return #N/A when no condition is met

`=IFS(B2<0,"Overdue",B2<=1,"Urgent",B2<=7,"This week",TRUE,"Later")`

Excel. Result on the sample sheet: 6 rows (C2:C7). [See it and try it](https://spreadsheetpractice.com/formulas/ifs-returns-na)

### Group invoices into aging buckets

`=LET(days,$G$1-B2,IFS(days<=0,"Current",days<=30,"1-30",days<=60,"31-60",days<=90,"61-90",TRUE,"Over 90"))`

Excel. Result on the sample sheet: 7 rows (D2:D8). [See it and try it](https://spreadsheetpractice.com/formulas/aging-buckets-for-invoices)

## Questions

### What does the IFS formula generator do?

You describe the task in plain English, and it writes the formula, using IFS where that's the right tool, for your table or a sample one. The formula is run in our engine in Excel and Google Sheets mode before you see it, so you get its result, not just a guess.

### What does IFS do?

IFS checks a list of conditions in order and returns the value paired with the first one that is TRUE.

### Can I learn to write IFS formulas myself?

Yes. Each example below opens a page where you try the formula in a live grid and it's checked as you go, and the IFS function page has a practice exercise.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
