ExcelBanter - Rounding Problem

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Rounding Problem (https://www.excelbanter.com/new-users-excel/156837-rounding-problem.html)

Rounding Problem

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

Rounding Problem

Check this link of John McGimpsey:

http://www.mcgimpsey.com/excel/pennyoff.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Alfred Kaufmann" wrote in message
...
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

Rounding Problem

See

http://www.mcgimpsey.com/excel/pennyoff.html

In article ,
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

Rounding Problem

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

Rounding Problem

you can also try to upgrade your reading within this page.

http://www.microsoft.com/office/comm...xp=&sloc=en-us

"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

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

Rounding Problem

glad it worked for your accounting sheet!<g

"Alfred Kaufmann" wrote:

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

Rounding Problem

I would suggest that you NOT use the "Precision as displayed" setting. It
can cause rather odd results in calculations if various cells have a
different number of decimal places. You should use ROUND instead.

See http://www.cpearson.com/newsletter/c...2007_08_27.htm

This article illustrates a rather simple case in which you can have three
different values when summing the same numbers.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

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