To get fomula to display a Zero

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
0
Geo (129)
12/30/2004 11:55:01 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
308 Views

Similar Articles

[PageSpeed] 58

=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


0
bob.phillips1 (6510)
12/30/2004 11:59:35 PM
Reply:

Similar Artilces: