Convert Kilo's to pounds and ounces

[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

 

[Don Guillett]

Have a look in HELP index for CONVERT.

 

[Guest]

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.

 

[Norman Harker]

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

 

[Guest]

Thanks very Much!!