You must round any calculation result before you compare it to a manually
entered quantity.
e7: =ROUND(SUM(C7:D7),1)
HTH
--
AP
"dls2193" <[email protected]> a écrit dans le message de
news: [email protected]...
>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
Bookmarks