IF - ELSE IF - ELSE Structure in Excel

Question

If the string in cell A1 contains "abc" as part of the string

Then assign value "Green"

Else if the string in cell A1 contains "xyz" as part of the string

Then assign value "Yellow"

Else

Assign value "Red"

Answer 1

If you need to test a condition, then take one action if the condition is TRUE, and another action if the condition if FALSE, you can use the IF function. The IF function has the concept of "else" built-in. The first argument is the logical test, the second argument is the result (or calculation) to return when the test is TRUE. The third argument is the value or calculation to run if FALSE.

1. If a cell in column D contains "S", return "Small".
2. If a cell in column D contains "L", return "Large".