Pounds (Lbs) to Stones & Pounds

**davidcrawt** · 10-04-2010, 05:14 AM

how do I get a cell to show Stones & Pounds (Weight) from Pounds?
In other words, if I put in 222 lbs, I want a cell to show this in Stones & Pounds

**Marcol** · 10-04-2010, 05:25 AM

Try this

=INT(A2/14)&"st "&MOD(A2,14)&"lb"

Hope this helps

**davidcrawt** · 10-04-2010, 05:56 AM

Originally Posted by Marcol

Try this

=INT(A2/14)&"st "&MOD(A2,14)&"lb"

Hope this helps

That's absolutely brilliant; thank you so much.

**Marcol** · 10-04-2010, 06:45 AM

Thanks, no problem.

You might want to have a look at this workbook for some more variations.

Re: Pounds (Lbs) to Stones & Pounds