Hi,


VBA evaluates both parts of the formula, the Excel worksheet IF function
only evaluates one part of the formula depending on whether the logical
condition is TRUE or FALSE


Tushar Mehta has an excellent tutorial on the IF function here

http://www.tushar-mehta.com/publish_...f_function.htm


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"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