How to prevent umpteen decimal places with this INT/MOD formula?

[halesowenmum]

Hi

I'm using this formula: =INT(J7/14) & "st " & MOD(J7,14)&"lbs"
to display a the lbs result result in Imperial stones and lbs however I'm getting some results such as

9st 2.30000000000001lbs - is there any way to prevent the lbs from going down to this level of detail so to speak since reducing the number of decimal places makes no difference.​

 

[63falcondude]

You cannot reduce the number of decimal places of a text string but you can reduce the number of decimal places directly from the formula itself using the ROUND function.

Something like this:

=INT(J7/14) & "st " & ROUND(MOD(J7,14),1)&"lbs"

 

[halesowenmum]

That'll do nice - thanks v much 63.

 

[63falcondude]

That'll do nice - thanks v much 63.

You're welcome. Happy to help.