Visio Chart

Charts & Graph For Data Visualization

IFS Function in MS Excel: Syntax, Arguments & Examples

What is IFS Function in MS Excel?

This is a premade function in MS Excel. It returns the result in the form of two values that is TRUE or FALSE.

Purpose of IFS Function in Excel

The IFS function in Excel is able to perform multiple tests on different values. It returns the result value when the value is TRUE. The main objective of the IFS function in MS Excel is to evaluate different conditions. This eliminates the need to use the nested IF function.

Syntax of IFS Function

The IFS function is written in the following way.

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

Arguments

The arguments used in the IFS function are described in the below section.

Test 1: this is the first test on the condition to get the return value.

Value1: this is the first returned value when the result is TRUE.

Test 2, value 2: this is an optional argument. This condition is tested when the value in the first condition is returned to be FALSE.

Examples

=IFS (C5<60,”F”, C5<70,”D”, C5<80,”C”, C5<90,”B”, C5>=90,”A”)

The above example is used to test the scores or grades. In this example, the lowest grades are evaluated first. The grade that is referred to as the TRUE value is returned as the result.

Scroll to top