| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Explaination of Logical If Then Statement
On Jul 18, 11:47 am, Mitchell
wrote: Can anyone explain to me why the following logical statement has the AND placed at the very beginning of the statement? =IF(AND($E964="",I964=""),"",IF($E964="",I964,IF($ G964="",I964,MROUND(I964,$G964)))) It's to tell Excel to get to the answer quickly that if both $E964 and I964 are "", then return a "" and don't bother figuring the rest of the formula. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statement with Two Different Logical Test | Excel Worksheet Functions | |||
| Logical statement for 'contains' ? | Excel Discussion (Misc queries) | |||
| IF STATEMENT - HOW TO STRUCTURE THE LOGICAL OPERATORS | New Users to Excel | |||
| Logical Statement | Excel Discussion (Misc queries) | |||
| 3 logical condition if statement | Excel Worksheet Functions | |||
Threaded Mode
