Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does an if statement calculate both the true and false?
I have a spreasheet, with 40000+ rows.
I have an if statement which is basically if(A1="OK",0,long and complex formula). Almost all instances are "OK" with a few exceptions requiring the complex, time consuming part of the formula. Does excel calculate that part of the formula even for cells which are "OK" and hence taking up loads of time, or does it ignore it knowing it doesn't need to return it? Thanks! Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRUE/FALSE STATEMENT | Excel Discussion (Misc queries) | |||
TRUE/FALSE function in IF statement | Excel Worksheet Functions | |||
Two TRUE to one FALSE statement | Excel Worksheet Functions | |||
If Statement returns true when false? | Excel Discussion (Misc queries) | |||
How can I make a True or False statement a certain color when usi. | Excel Worksheet Functions |