How to Use the IFS Function. In simple terms, the IFS function tests one or more conditions and returns a value based on the outcome. To use this function, you’ll need to know the criteria you want to ...

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