1. Technology

Excel Logical Functions

Excel's Logical Functions can be used to introduce decision making into your spreadsheet.

The IF function tests to see if a certain condition in a spreadsheet is true...
The IF function tests to see if a certain condition in a spreadsheet is true or false.

Excel OR Function
The OR function is one of Excel's Logical Functions. Like most logical functions, the output from the OR function is either the word TRUE or FALSE. This article walks you through how to use this function in Excel 2007

Excel AND Function
The AND function is one of Excel's Logical Functions which means the output will either be TRUE or FALSE. This tutorial walks you through how to use the AND function in Excel.

Excel Rolling Dice Tutorial
The AND and OR functions are seldom used on their own in Excel. Often they are used with the IF function to test multiple conditions. This tutorial shows you how to combine the IF function with both the AND function and the OR function.

Excel Nested AND and IF Function Tutorial
This tutorial covers nesting the AND function inside the IF function. By combining functions in this manner there is an increase in the number of possible outcomes for the function.

Excel Nested OR and IF Function Tutorial
The OR function is one of Excels Logical Functions. Like most logical functions, the OR function only returns a true or false result. To determine whether the output will be true or false, the function evaluates at least one expression located in another cell in the spreadsheet.

You can opt-out at any time. Please refer to our privacy policy for contact information.

©2014 About.com. All rights reserved.