Not sure I follow you: you want g35 to return 0 when g32 = 0? If
that's the case another IF() function can do it for you:

=IF(g32=0,0,SUM(G32,-69.4*113/119))

Is that what you need?


Geo wrote:
This solution worked great but I still have a problem in another
area. This
formula in G35 generates a number when the cell G32 is
"0"=SUM(G32,-69.4*113/119) which is probably what I'm telling it to
do.
(Doing the formula on my calculator yields -65.9008 which is what
excell G35
does.) I have tried substituting my other fix(Below) but am having
trouble
making it also display "0".

"Dave O" wrote:

One way to do it is to use an IF() function:
=IF(SUM(G9:G17)=0,0,SUM(G9:G17,-36))

This instructs Excel to return a zero value if the sum of cells g9
thru
g17 is zero, and performs your original SUM(G9:G17,-36) operation
if
the sum is not zero.