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

For a nested IF function like this, you have to take the values in order: either start with the highest value and work your way down to the lowest, or work from the lowest value to the highest. The ...