View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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

--

HTH

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


"Geo" wrote in message
...
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