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

For more complex scenarios, Excel also offers the IFS function, which allows multiple conditions to be tested in a single formula without nesting/complicated syntax. IFS statements are written ...