Ifs

 

Use the IFS function in Excel 2016 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, you can nest the IF function.

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

First Ifs Function in Excel, Value 1

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

First Ifs Function, Value 2

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

First Ifs Function, Value 3

1d. If 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 cell A1 is less or equal to 10, the IFS function returns 350.

Second Ifs Function in Excel, Value 6

2b. If cell A1 is greater than 10 and less or equal to 20, the IFS function returns 700.

Second Ifs Function, Value 12

Second Ifs Function, Value 20

2c. If cell A1 is greater than 20 and less or equal to 30, the IFS function returns 1400.

Second Ifs Function, Value 27

2d. If cell A1 is greater than 30, the IFS function returns 2000.

Second Ifs Function, Value 54

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

Do you like this free website? Please follow us on Google+

3/5 Completed! Learn more about logical functions >
Back to Top: Ifs   |   Go to Next Chapter: Cell References