Hi,

Wonder if anyone can help.

I have a formula which is something like this:

=IF(G3=0,"-",=big formula) where "big formula" is, erm, a big formula. The
result is currently showing #VALUE even though G3 does equal zero. I have
confirmed this by highlighting the G3=0 part of the formula and pressing F9
where it shows in the formula bar that this is TRUE. Furthermore if I make
G3 equal to something other than zero the big formula works.

Can anyone tell my why I might be getting this #VAUE?

Thanks very much,

Andrew