I Have a foumula in G35 that takes the sum of 2 other cells(G32).This formula
"=SUM(G32,-69.4*113/119)" in G35 generates a number when the sum in the cell
G32 is 0, which is probably what I'm telling it to do. But in reality I would
like G35 to display a "0"
(Doing the formula on my calculator yields -65.9008 which is what excell G35
does.) I have tried using a fix that was supplied to me earlier. Can someone
Help please?
--
Geo

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Geo" wrote in message
...
I Have a foumula in G35 that takes the sum of 2 other cells(G32).This
formula
"=SUM(G32,-69.4*113/119)" in G35 generates a number when the sum in the
cell
G32 is 0, which is probably what I'm telling it to do. But in reality I
would
like G35 to display a "0"
(Doing the formula on my calculator yields -65.9008 which is what excell
G35
does.) I have tried using a fix that was supplied to me earlier. Can
someone
Help please?
--
Geo