See this short tutorial video for Windows and Mac users for a step-by-step overview of how to use the IFS function to calculate letter grades. In case you were wondering, the IFS function has a limit ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

When analyzing grades (especially for a large class) the COUNTIF function in Excel can be extremely helpful.

Other Excel tutorials and resources Overall, the COUNTIF () function is fairly simple to use — it’s the condition expressed in criteria that might cause confusion.