spot_img

IFS Function

 

Use the IFS function in Excel 2016 or later when you have multiple conditions to meet. The IFS function returns a value corresponding to the first TRUE condition.

Note: if you don’t have Excel 2016 or later, you can nest the IF function.

1a. If the value in cell A1 equals 1, the IFS function returns Bad.

First Ifs Function in Excel, Value 1

1b. If the value in cell A1 equals 2, the IFS function returns Good.

First Ifs Function, Value 2

1c. If the value in cell A1 equals 3, the IFS function returns Excellent.

First Ifs Function, Value 3

1d. If the value in cell A1 equals another value, the IFS function returns No Valid Score.

First Ifs Function, Else

Note: instead of TRUE, you can also use 1=1 or something else that is always TRUE.

Here’s another example.

2a. If the value in cell A1 is less than 60, the IFS function returns F.

Second Ifs Function in Excel, Value 41

2b. If the value in cell A1 is greater than or equal to 60 and less than 70, the IFS function returns D.

Second Ifs Function, Value 60

2c. If the value in cell A1 is greater than or equal to 70 and less than 80, the IFS function returns C.

Second Ifs Function, Value 73

2d. If the value in cell A1 is greater than or equal to 80 and less than 90, the IFS function returns B.

Second Ifs Function, Value 82

2e. If the value in cell A1 is greater than or equal to 90, the IFS function returns A.

Second Ifs Function, Value 95

Note: to slightly change the boundaries, you might want to use “<=” instead of “<” in your own function.

spot_img
Previous articleCapital Investment in Excel
Next articleActiveX Controls in Excel VBA