Zero Formula

Sam Shepherd

i am using:

=([Benefit 1 - Efficiency]@row + [Benefit 2 - Quality]@row) * 3 and it works but in blank cells i get zeros

if i change it to this:

=IF(SUM([Benefit 1 - Efficiency]@row + [Benefit 2 - Quality]@row) * 3),=0,"",SUM([Benefit 1 - Efficiency]@row + [Benefit 2 - Quality]@row) * 3

I get #UNPARSEABLE

Help.................

Mark Safran

Hi Sam,

Assuming your goal is for the formula to yield a blank if both of the benefit columns are blank, then it looks like you just had your syntax wrong for the IF statement. Give this a shot:

=IF((([Benefit 1 - Efficiency]@row + [Benefit 2 - Quality]@row) * 3) = 0, "", (([Benefit 1 - Efficiency]@row + [Benefit 2 - Quality]@row) * 3))

-MS

Sam Shepherd

Brilliant thanks