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 |
=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 |
All times are GMT +1. The time now is 04:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com