I am familiar with the round function. It seems odd that there can be such
discrepency when summing only two numbers. Thanks to all who replied!

dls2193

"Ardus Petus" wrote:

You must round any calculation result before you compare it to a manually
entered quantity.

e7: =ROUND(SUM(C7:D7),1)

HTH
--
AP
"dls2193" a écrit dans le message de
news: ...
I have an issue with excel:

cell c7: 123200 (entered direct into cell-not calculated)

cell d7: -123151.6 (entered direct into cell-not calculated)

cell e7 forumula: =sum(c7:d7)

result displayed: 48.4 (appears correct)

cell j7 value = 48.4 (entered direct into cell-not calculated)

cell j7 formula: =j7=e7 result: FALSE

When I copy paste special values from cell e7 to another cell the result
is
48.3999999999942.

How can that be? What is the problem? This is simple math. It has been
tested on multiple computers with similar configuration. Please help.

MS office 2003 (11.6355.6408) SP1
MS Windows XP V2002 SP1

dls2193