Nested If

 

The IF function can be nested, when you have multiple conditions to meet. The FALSE value is being replaced by another If function to make a further test. For example, look at the formula below.

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

First Nested If Formula, Value 1

Advertisement

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

First Nested If Formula, Value 2

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

First Nested If Formula, Value 3

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

First Nested If Formula, Else

Here's another example.

2a. If cell A1 is less or equal to 10, the function returns 350.

Second Nested If Formula, Value 6

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

Second Nested If Formula, Value 12Second Nested If Formula, Value 20

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

Second Nested If Formula, Value 27

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

Second Nested If Formula, Else

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

Advertisement

Please show your appreciation by sharing this page

Go back to logical functions, Go to the right >>
Go to Top: Nested If    |    Go to Next Example: Roll the Dice