How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial

This article was co-authored by wikiHow staff writer, Kyle Smith . Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo. The wikiHow Tech Team also followed the article's instructions and verified that they work. This article has been viewed 122,844 times. Learn more...

This wikiHow guide will show you how to use the IF function in Microsoft Excel to create logic formulas. If-else statements indicate that one value should appear “if” a condition is met, “else” show a different value if the condition isn’t met. The IF function allows you to evaluate a condition and output a different value for when the condition is true or false. You can add in AND, OR, and NOT functions to create more complex logical conditions. Use nested IF statements to create multiple conditions that must be met and different paths.

Use =IF(logical_test, [value_if_true], [value_if_false]) to create an if-else statement.

Add AND, OR, or NOT functions to evaluate more complex situations.

Create nested IF statements to evaluate multiple conditions at different levels.