Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation problem - please help
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation problem - please help
See
http://www.mcgimpsey.com/excel/pennyoff.html In article , "Neil Hindry" wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation problem - please help
"Neil Hindry" wrote in message
... 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). -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mortgage calculation after a large extra payment | Excel Discussion (Misc queries) | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
Problem withe ABS Function | Excel Worksheet Functions | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |