Use multiple IF statements in a single Excel formula by nesting them inside parentheses.
In programming languages, IF statements are used to evaluate a condition and perform either one of two actions, depending on whether the condition is met. For example, Web applications use IF statements to evaluate whether the text a user enters into a form is a valid email address. The application then either does nothing or displays a "Please enter a valid email address" message, based on the evaluation of the condition.
While IF statements exist in all modern programming languages, they can also be used in Excel to insert one of two possible values into a cell, depending on whether the condition evaluates to true or false.
The basic structure of an IF statement in an Excel formula is:
=IF(Condition, Value if condition is true, Value if condition is false)
After testing the condition, Excel returns either one of the two supplied values, based on whether the condition evaluated to true or false.
For example, the following IF statement would return "Yes" if the A1 cell contains the word "Banana" and "No" if it contains any other value:
Multiple IF Statements
Multiple IF statements let you evaluate a condition that has more than two possible outcomes. To create a multiple IF statement, replace the value returned if the condition is evaluated to false in the first statement by a second IF statement, enclosed in its own set of parentheses.
For example, this formula containing two IF statements checks whether the person whose age -- expressed in years -- in cell A2 is a child, a teenager or an adult:
The statement executes as follows:
- Excel evaluates whether the age entered in cell A1 is lower than 13. If it is, the "Child" value is assigned to the cell that holds the formula, and Excel does not execute the rest of the statement. If the age is equal to 13 or greater, the condition evaluates to false and the second IF statement executes.
- Excel then checks whether the age is lower than 20 and returns either "Teenager" if it is, or "Adult" if the age is equal to 20 or greater.