On Mar 31, 5:13*pm, chriswilko
wrote:
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

Hi Chris,

If the value is "OK", it will check for the TRUE value and exit the
function... so no need to worry about the complex satement incase the
value is "OK"

Ratheesh