Tips.Net > ExcelTips Home > Worksheet Functions > Logical Functions

 

Tips, Tricks, and Answers

The following articles are available. 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Bugs and Pests Tips
ExcelTips
Family Tips
Health Tips
Home Tips
Organizing Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)

RSS Feeds

RSS 2.0 Daily Nuggets (an ExcelTip every day)

RSS 2.0 Allen Wyatt's ExcelTips (the weekly classic)