IFS Function

With IFS Function you don’t need to deal with nested IF functions anymore. IFS is an if function that can take multiple conditions.

When there is a situation that you need to evaluate multiple conditions at once, you normally need to use multiple if functions together (nested if functions).

For example, you need to evaluate test scores based on the table below:

 

To achieve this in a formula, you need to build a nested if function like below:

=IF(D10>D3,”Very Good”,IF(D10>D4,”Good”,IF(D10>D5,”Normal”,IF(D10>D6,”Bad”,”Very Bad”))))

This formula has four if functions nested together.

Instead, you can achieve same result by using just one IFS function. Here how it is:

=IFS(D10>D3,”Very Good”,D10>D4,”Good”,D10>D5,”Normal”,D10>D6,”Bad”,D10<D6,”Very Bad”)

So, all you need to do with IFS function is to give a condition and a value for that condition repeatedly. You can use up to 127 conditions.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.