Rounding Problem
Thanks everyone, that Round function should solve the problem. I also
discovered in the Excel Options how to set the precision to what is
displayed. Just have to ignore that terrible warning that my
spreadsheet will lose accuracy.
Al
I use Excel so often that every time I do Micsoft has a new version
;-(
On Mon, 3 Sep 2007 14:16:00 -0700, swordsman
wrote:
did you try
=Round((A+B)*1.06,2)
will there be no problem in your accounting sheet if you do so?
"Alfred Kaufmann" wrote:
I have got a very simple accounting spreadsheet where column C is
determined by (A+B)*1.06. Cell C is formatted for dollars - two
decimal places. At the bottom of column C is a total which is usually
correct but sometimes it is out by one cent. All the calculations
across are correct. I am sure there is an easy way to fix this isn't
there? Thanks.
Al
|