If Then Else Statement

August 15th, 2004 | Categories: Formulas | Tags:

IF Then Else statements look a bit intimidating to newbies, but here are the basics to clear things up.

We will use this picture in our example.

This returns “Oh Yeah” if June sales are greater than April’s and “Uh-oh” if not.

The basic Layman’s syntax for an If then else statement is:
=If(Evaluation,”Istrue”,”IsFalse”)

To make it work:
1. Replace “Evaluation” with the equation to evaluate. In this case we want to display a message IF June sales(B2) are greater than(>) April Sales(A2).
2. Replace “Istrue” with the text to display if June sales are greater than April sales
3. Replace “Isfalse” with the text to display if June sales are less than April sales


Variation: AND
If you would like to display a message if both figures are greater than a value try the AND syntax

=If((AND(Evaluation1,Evaluation2)),”Istrue”,”IsFalse”)


Variation: OR

If you would like to display a message if one or the other figures are greater than a value try the OR syntax

=If((OR(Evaluation1,Evaluation2)),”Istrue”,”IsFalse”)


Get LIVE Help
Custom Excel solutions & live Excel help!
► Go to www.ExcelAutomationHelp.com
► Email Now@ExcelAutomationHelp.com
No comments yet.