Excel IFS function

Function              IFS

Description        Excel IFS function performs multiple tests and returns a value corresponding to the first TRUE result.

Syntax  IFS(test1, value1, [test2, value2], …)

test1  First logical test.

value1  Returning value when test1 is TRUE.

Test2  Second logical test.

Value2  Returning value when test2 is TRUE.

Example:

I am having marks in a cell A1 and I have to decide the grade of marks (Grade A: >=85, Grade B: >=70, Grade C: >=55, Grade D:>=40, Grade E:>=25)

then I will put this formula

=IFS(A1>84,”A”,A1>69,”B”,A1>54,”C”,A1>39,”E”,A1>24,”E”, TRUE, “FAIL”)

It will return “FAIL” when Marks<25