Convert Kilo's to pounds and ounces

  • Thread starter Thread starter kls
  • Start date Start date
K

kls

Hi, is there a formula to convert kilo's into pounds? i
can convert simply multiplying the kilos by 2.2 and
dividing by 16, but this gives me 'decimal' answer (i.e
instead of 93 kilos returning 12 stone 12 ounces, it
returns 12.75) - Thanks
 
Thanks, but this only converts from kilos to lbs or
ounces. i wanted to convert from kilos to stones and
pounds. Any more help?

thanks.
 
Hi

Use kg for the from unit
Use lbm for the to unit

That gives the result in lbs.

To get stones you divide the result by 14.

If you want stones and pounds then you can use something like:

=INT(CONVERT(A1,"kg","lbm")/14)&" stones
"&MOD(CONVERT(A1,"kg","lbm")/14,1)*14&" pounds"

or:

=CONVERT(A1,"kg","lbm")/14
format: # ?/14
 
Back
Top