Hello Juliet...
Could you please state what occupies those cells : (v2+z2+ad2+af2) ? I see
nothing wrong with the syntax of your IF formula, so I'm suspecting the
problem lies in those four cells. Thank you... Roger H.
"Juliet" wrote in message
...
My formula is:

=IF(B2=1,"",(v2+z2+ad2+af2))

(B2 is either 0 or 1)

However, this gives a blank result for every cell, even when B#=0. When I
evaluate the formula through formula auditing the evaluation shows the
formula should work. Am stumped!

I have tried to re work the formula in several ways, if turned around
(B#=0,(#+#+#), "") it inserts the summed value in every cell and none are
blank even if (for example) B43=0

Hope you can help

Juliet