To get fomula to display a Zero

G

Geo

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?
 
B

Bob Phillips

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

--

HTH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top