To get fomula to display a Zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=IF(G32=0,0,SUM(G32,-69.4*113/119)

--

HTH

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