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