Contents
An Introduction to Excel Functions
Financial Functions
Date and Time Functions
Math and Trigonometry Functions
Statistical Functions
Lookup and Reference Functions
Database Functions
Text Functions
Logical Functions
Information Functions
Engineering Functions
Cube Functions
Add-In and Automation Functions
Logical Functions
Function |
Description |
Syntax |
||
AND |
Returns TRUE if all of its arguments are TRUE |
(logical1,logical2,...) |
||
FALSE |
Returns the logical value FALSE |
( ) |
||
IF |
Specifies a logical test to perform |
(logical_test,
value_if_true,
value_if_false) |
||
IFERROR |
Returns a value that you specify if a formula evaluates to an error; otherwise, returns the result of the formula |
(value,value_if_error) |
||
NOT |
Reverses the logic of its argument |
(logical) |
||
OR |
Returns TRUE if any argument
is TRUE |
(logical1,logical2,...) |
||
TRUE |
Returns the logical value TRUE |
( ) |
| Acknowledgments & Disclaimer |
Tags
No one has tagged this page yet... Be the first.. Log in using the link below and return to add your tag






