Google Sheets reference

IFS in Google Sheets

Works in Google Sheets1 worked example

Worked examples (1)

These formulas work in Google Sheets with identical syntax.

Conditional Logicintermediate

=IFS(A2>=10000,"Gold",A2>=5000,"Silver",A2>=1000,"Bronze",TRUE,"Standard")

Also in Excel

See the full IFS reference for Excel — including all worked examples, common errors, and FAQ.