One way to do this in Excel is to use a series of nested IF functions.
You’ll often hear this referred to as “nested IFs”.
The idea of nesting comes from embedding or “nesting” one IF function inside another.
In the workbook shown, we are nesting IF functions to assign grades based on a score.
In this example, we start at the bottom.
If the result is FALSE, we move into the next IF function.
We don’t need to worry about scores less than 64 anymore, because that case is already handled.
At this point, the only condition to check is if the score is between 95 and 100.
The Excel formula engine will ignore them.
One workaround is to use TRUE as the last test, which you could see in the formula below.
Read more:How to use the IFS function.
More than one condition can be tested by nesting IF functions.
Use the IFS function to evaluate multiple conditions without multiple nested IF statements.
