Logical Functions
The Excel logical functions include the boolean operators and conditional tests.
All the Excel logical functions are listed below. Please click "Example" for geting full description of the function, with examples of use.
| Functions |
Syntax |
Tutorial |
| IF Function |
IF(logical_test, [value_if_true], [value_if_false]) |
Example |
| IFS Function |
IFS(logical_test1, value if true,….) |
Example |
| IFERROR Function |
IFERROR(VALUE,value_if_error) |
Example |
| AND Function |
AND(logical1,logical2) |
Example |
| OR Function |
OR(logical1,logical2) |
Example |
| Excel NOT Function |
NOT(ligical) |
Example |