Did you enter these by hand, or are they the result of a formula?
If the latter, try increasing the number of decimal points. You'll find
that either M1 or M2 are slightly less than their displayed values, but
they are rounded to 0 or 2 decimal places by the display engine. As a
workaround, try enclosing the M2 function in a ROUND(<function>,2)
formula, for example.
In article <#dwfNswQFHA.3076@tk2msftngp13.phx.gbl>,
"FM" <fm@ncinternet.com> wrote:
> I recent found a problem and need help to solve.
>
> If I enter the the data in the following columns, using the example entries
> I get different answers:
>
> M1 M2 M3
> 24 2.18 =M1*M2 results in 52.22
>
> 24 2.18 =24*2.18 results in 52.32
>
> The 52.32 is the correct answer needed.
Bookmarks