Logical Functions

Tips, Tricks, and Answers

The following articles are available for the 'Logical Functions' topic. Click the article's title (shown in bold) to see the associated article.

Nesting IF Worksheet Functions
One powerful worksheet function is the IF function, which allows your formulas to make "decisions" based on whatever test you specify. This tip explains how you can use this great function in your own formulas.

Using the IF Worksheet Function
Programmers know that a staple of any language is the ability to create conditional statements. Excel understands this, as well, so it provides the IF worksheet function that allows you to evaluate an expression and thereby conditionally choose a result.