Concatenating a Calculation with Text causes the Calculation to be incorrect??

[Nelson]

In one cell I type this:
=MOD(413.224,1)*250

The correct result appears:
56

If I put this same formula into another cell with concatenating text:
=MOD(413.224,1)*250 & " LF"

The incorrect result appears:
55.9999999999974 LF


The result I am looking for is:
56 LF


Why the incorrect calculation? Am I doing something wrong? How can I get
the value I want?

 

[Vasant Nanavati]

Try:

=TEXT(MOD(413.224,1)*250,"#,##0") & " LF"

Excel's binary arithmetic cannot add decimals accurately. The reason you are
getting the "correct" answer in the first instance is probably because of
the way the cell is formatted for numbers.

 

[Frank Kabel]

Hi
try
=TEXT(MOD(413.224,1)*250,"0.00") & " LF"

 

[gkelle]

Try using
=ROUNDUP((MOD(413.224,1)*250),0) & " LF

 

[Nelson]

Thanks everyone! I used the Text function as you explained. Thanks for
giving me the example too!

Chris