miscalculation in excel

G

GSHEP

adding 989.89 to 165.2
cells G23 H23


=G23+H23 in spreadsheet

answer should be 1155.09 calculation given is 1155.04
 
J

JLatham

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?
 
R

Ron Rosenfeld

adding 989.89 to 165.2
cells G23 H23


=G23+H23 in spreadsheet

answer should be 1155.09 calculation given is 1155.04
Click to expand...

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
 
J

joeu2004

GSHEP said:
adding 989.89 to 165.2
cells G23 H23
=G23+H23 in spreadsheet
answer should be 1155.09 calculation given is 1155.04
Click to expand...

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
 
S

SteveW

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
 
Top