On Sat, 16 Apr 2005 22:05:11 -0700, "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.
>
>Thanks
>FM
>

It is likely that the contents of M1 and/or M2 is not exactly 24 and 2.18
respectively, but that the display is rounded to those values.

When you are obtaining the above, what do the following formulas give for
results?

1. =M1=24
2. =M2=2.18

What do M1 and M2 look like if you Format/Cells/Number Decimal Places:15


--ron