Calculation problem - please help

[Neil Hindry]

I wonder if you can help me. I have recently purchased MS Office 2003 and I
have a small but annoying problem in Excel.
I am doing a spreadsheet relating to my finances. I have formatted the
figures as currency with 2 decimal places, and the £ symbol as the symbol
before the figures.

In one part of the spreadsheet I have a very simple calculation it is 411.67
* 12
which should equal 4940.04

However, in the spreadsheet it displays the answer as 4940.00

Why is it not adding up the pence correctly? I now it is only a small thing
but in some other spreadsheets if it does that all the time it could make
quite a difference.

I should point out that this is a spreadsheet that was created in Excel from
Office XP.

Whenever I create a blank spreadsheet and try this calculation it works
correctly.

Has anyone else noticed this?

How can I fix it?

I hope you can help me.

I appreciate any help or information given.

Thanks!

 

[JE McGimpsey]

See

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

 

[David Biddulph]

I wonder if you can help me. I have recently purchased MS Office 2003 and
I have a small but annoying problem in Excel.
I am doing a spreadsheet relating to my finances. I have formatted the
figures as currency with 2 decimal places, and the £ symbol as the symbol
before the figures.

In one part of the spreadsheet I have a very simple calculation it is
411.67 * 12
which should equal 4940.04

However, in the spreadsheet it displays the answer as 4940.00

Why is it not adding up the pence correctly? I now it is only a small
thing but in some other spreadsheets if it does that all the time it could
make quite a difference.

I should point out that this is a spreadsheet that was created in Excel
from Office XP.

Whenever I create a blank spreadsheet and try this calculation it works
correctly.

Has anyone else noticed this?

How can I fix it?

I hope you can help me.

I appreciate any help or information given.

Thanks!

Is it actually 411.67 * 12, or is it 411.6666666...67 * 12 ?
Have you displayed the 411.6666666...67 with a format of 2 decimal places,
which of course would display as 411.67?
If you actually want to round the number at that stage, rather than merely
displaying it to the rounded precision, you can use a function such as
ROUND(A1,2).