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

We will then compare ... use the IFS function, which is an upgraded version of IF capable of handling multiple criteria. The IF statement is one of the most useful functions in Excel.