Logic Function Review
A review of logic functions in Excel.
When to use
Constructing models that allow you to dynamically react to changes in inputs, returning different results based on the inputs.
- Testing a cell versus another cell or text via the following format =A1=B1 or =A1=”Product”
- Results will be TRUE if the data matches, or FALSE if it does not
The IF Function
- Allows you to return different results in the case of a TRUE or FALSE result from a test
- Basic Syntax: =IF([Scenario to test],[What to do if TRUE],[What to do if FALSE])
- Example: =IF(A1>0,”Bank is positive”,”Funds required!”)
Working with AND vs OR
- Allows combining multiple tests
- =AND(A5=5, B5=6) Will return TRUE if A5=5 AND B5=6. (Both conditions must be met.)
- =OR(A5=5, B5=6) Will return TRUE if either A5=5 OR B5=6. (Either condition can be met.)
Hints & tips
- The “Scenario to test” must always be something that evaluates to TRUE or FALSE
- IF statements can be nested to make more complex tests
Lesson notes are only available for subscribers.