Logical Functions: IF & AND

Make decisions in your spreadsheet using IF statements.

=IF(logical_test, value_if_true, value_if_false)

You can nest them for multiple conditions:

=IF(A1>90, 'A', IF(A1>80, 'B', 'C'))

If you have Excel 365, use the IFS function to avoid messy nested brackets!