Excel Logical Functions

Special

Excel Functions

2003

Special

Excel Functions

2007

Lesson 6: Excel Spreadsheets Logical Functions (7)

In annex 6 you have found a description of all 7 Excel functions in the "Logical" category. Below is the list of the 4 most useful ones. See more on IFERROR in lesson 25

Functions	What it Does
AND	Returns TRUE if all its arguments are TRUE
IF	Specifies a logical test to perform
NOT	Reverses the logic of its argument
OR	Returns TRUE if any argument is TRUE
New in Excel 2007
IFERROR	Returns a specified value if the formula results in an error otherwise returns the result of the formula

In the downloadable tutorial on Excel functions and formulas you will find example of formulas using each of these functions and even many of them assembled in easy and powerful formulas.

Go to the next lesson:
Lesson 7: Excel Lookup and Reference Functions

See the complete version of this lesson in
The Tutorial on Excel
Functions