Excel IFS function will work in Excel 2016, Excel Online, Excel for Android tablets, Excel Mobile, Excel for Android phones.
About excel IFS function:
Excel IFS function checks multiple condition and returns value for first TRUE condition.
IFS function can be used instead of using nested if function to check multiple if condition in one formula.
This makes formula easy to understand, you can enter up to 127 conditions in one formula.
Disadvantage of this function is that we can’t define the ELSE condition.
It will give #N/A error if non of the conditions are TRUE.
logical_test1: The first condition you want to test. value_if_true1: Result if the first condition is true logical_test2: The second condition you want to test. value_if_true2: Result if the second condition is true
This function will check the conditions in order and will return the value for the first condition which is true.
Using IFS function:
As mentioned above, we can use this function instead of nested if function where there are many if conditions to be tested.
In this example we will check how to calculate the grade for marks obtained with IFS function.