Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
miscalculation in excel
adding 989.89 to 165.2
cells G23 H23 =G23+H23 in spreadsheet answer should be 1155.09 calculation given is 1155.04 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
miscalculation in excel
Excel 2003 says 989.89+165.2 is 1155.09
G23 contains 989.89 H23 contains 165.2 I23 set as =G23+H23 shows 1155.09 Something else in the formula you're using? "GSHEP" wrote: adding 989.89 to 165.2 cells G23 H23 =G23+H23 in spreadsheet answer should be 1155.09 calculation given is 1155.04 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
miscalculation in excel
Answer should be 1154.91 using just the figures supplied.
Increase decimal places in the two cells and see what you really have in G23 and H23 John McGimpsey has some info at this site http://www.mcgimpsey.com/excel/pennyoff.html Gord Dibben MS Excel MVP On 30 Sep 2006 05:26:30 -0700, "GSHEP" wrote: adding 989.89 to 165.2 cells G23 H23 =G23+H23 in spreadsheet answer should be 1155.09 calculation given is 1155.04 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
miscalculation in excel
On 30 Sep 2006 05:26:30 -0700, "GSHEP" wrote:
adding 989.89 to 165.2 cells G23 H23 =G23+H23 in spreadsheet answer should be 1155.09 calculation given is 1155.04 Then the contents of G23 and H23 is not 989.89 and 165.2 Format the G23 and H23 as General, or Number with a lot of decimal places, and see what the contents of those cells is really. --ron |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
miscalculation in excel
GSHEP wrote:
adding 989.89 to 165.2 cells G23 H23 =G23+H23 in spreadsheet answer should be 1155.09 calculation given is 1155.04 Probably an example of displayed v. actual precision of the numbers in G23 and H23. The number displayed as "989.89" could be as small as 989.885. The number displayed as "165.2" could be as small as 165.15. Their sum could be as small as 1155.035. The number displayed as "1155.04" could be as small as 1155.035 or as large as 1155.0449...9. So the values in G23 and H23 could be larger than their smallest possible, and their sum could still display as "1155.04". Increase the precision of the cells (Format Cells Number Number Decimal Places), and you should the cause of the problem. You can usually avoid such anomalies by using ROUND() judiciously. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
miscalculation in excel
or maybe just make the columns a tad wider !
I can reproduce your problem, by have the 3 cells in different columns and narrowing them until they show the values you have. Auto-fit the 3 cells and bingo all correct Steve On Sat, 30 Sep 2006 23:58:50 +0100, wrote: GSHEP wrote: adding 989.89 to 165.2 cells G23 H23 =G23+H23 in spreadsheet answer should be 1155.09 calculation given is 1155.04 Probably an example of displayed v. actual precision of the numbers in G23 and H23. The number displayed as "989.89" could be as small as 989.885. The number displayed as "165.2" could be as small as 165.15. Their sum could be as small as 1155.035. The number displayed as "1155.04" could be as small as 1155.035 or as large as 1155.0449...9. So the values in G23 and H23 could be larger than their smallest possible, and their sum could still display as "1155.04". Increase the precision of the cells (Format Cells Number Number Decimal Places), and you should the cause of the problem. You can usually avoid such anomalies by using ROUND() judiciously. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |