![]() The OR function takes up to 255 logical tests. If you see the power of AND, then you will appreciate the OR and NOT functions. Use the AND() function as the logical test inside the IF statement. If any argument is false, then AND will return FALSE. The AND function will return TRUE if all of its arguments are TRUE. The AND function will hold up to 255 logical tests. The above approach becomes unwieldy, as the formula is =IF(Test1,IF(Test2,IF(Test3,IF(Test4,IF(Test5, Formula If True,0),0),0),0),0). Imagine if you had to test for five conditions. ![]() This will provide the third argument and closing parentheses for the first IF statement. Gotcha: Don't forget to type the ,0) at the end of the formula.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |