Appendix F: Excel Spreadsheets Logical Functions List (6)
This web page is an appendix. For more see Excel Logical formulas in lesson 3-12
Here is the list of the functions of the logical category. Of the 6 functions of the logical category 4 are interesting and useful. Follow the links below to discover formulas using them.
The IF fucntion is particularly Essential when coupled with ISERROR
| Importance | Functions | What it Does |
| Interesting | AND | Returns TRUE if all its arguments are TRUE |
| Essential | 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 |