To calculate letter grades based on a percentage score, you can use multiple nested IF statements in Excel, which can get rather complicated quickly. However, there is an easier way. Added by ...

With the SWITCH function, you do not need to repeat the expressions again and again as in the IFS function. For example, the IFS function below finds the exact states. Explanation: Cell A2 contains ...