Learn how to use IF & nested IF statement in Google Sheets. & highlight a row using conditional formatting, set up multiple conditional formatting rules.

Nested IF statements allow testing multiple conditions within a single formula. You can also use other Excel functions in IF statements to perform calculations.

Added by Microsoft in 2016, the IFS function replaces the need for multiple nested IF statements. You can put all your conditions (percentage grade cutoffs in this example) in one function, making it ...