Excel Spreadsheets Logical Functions (7)
There is a new function in Excel 2007 in this category.
Importance
Functions
What it Does
Interesting
AND
Returns TRUE if all its arguments are TRUE
Interesting
IF
Specifies a logical test to perform
Interesting
NOT
Reverses the logic of its argument
Interesting
OR
Returns TRUE if any argument is TRUE
Rarely Used
FALSE
Returns the logical value FALSE
Rarely Used
TRUE
Returns the logical value TRUE
In Excel 2007 and Up
Interesting
IFERROR
Returns a specified value if the formula results in an error otherwise returns the result of the formula