View Single Post
  #1   Report Post  
Geo
 
Posts: n/a
Default 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