Google Sheets reference

IF in Google Sheets

Works in Google Sheets1 worked example

Worked examples (1)

These formulas work in Google Sheets with identical syntax.

Conditional Logicbeginner

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

Also in Excel

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