The IF function formula syntax The IF function has a simple syntax with only three arguments, making it easy to use. The syntax is IF (test, if_true, if_false) where only the first two arguments ...

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 ...