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" <Geo@discussions.microsoft.com> wrote in message
news:712FB21A-1F30-4A54-A64F-0C82B27A9002@microsoft.com...
> 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