Kilos to Stones & Pounds

[Chris Swatton]

I used the formula below, given elsewhere on this site to convert kilos into
Stones & Pounds.

=INT(CONVERT(F6,"kg","lbm")/14)&"st "&MOD(CONVERT(F6,"kg","lbm")/14,1)
*14&"lb" When I converted 98 kilos I got the following result 15st 6.
05304563975091lb. Could someone advise how I can amend the formula to round
up or down the decimals so that the result would show 15st 6lb.

 

[MH]

=INT(F6*2.2/14)&"st "&ROUND(MOD(F6*2.2,14),0)&"lb"

MH

 

[RagDyeR]

Try this:

=INT(CONVERT(F6,"kg","lbm")/14)&"st
"&ROUND(MOD(CONVERT(F6,"kg","lbm")/14,1)*14,0)&"lb"

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I used the formula below, given elsewhere on this site to convert kilos into
Stones & Pounds.

=INT(CONVERT(F6,"kg","lbm")/14)&"st "&MOD(CONVERT(F6,"kg","lbm")/14,1)
*14&"lb" When I converted 98 kilos I got the following result 15st 6.
05304563975091lb. Could someone advise how I can amend the formula to round
up or down the decimals so that the result would show 15st 6lb.

 

[Bob Phillips]

=INT(CONVERT(F6,"kg","lbm")/14)&"st
"&ROUND(MOD(CONVERT(F6,"kg","lbm")/14,1)*14,0)&"lb"

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[ChrisSwatton via OfficeKB.com]

Thanks for your help

=INT(F6*2.2/14)&"st "&ROUND(MOD(F6*2.2,14),0)&"lb"

MH

I used the formula below, given elsewhere on this site to convert kilos
into

[quoted text clipped - 5 lines]

round
up or down the decimals so that the result would show 15st 6lb.

 

[ChrisSwatton via OfficeKB.com]

Thank you for your help

Try this:

=INT(CONVERT(F6,"kg","lbm")/14)&"st
"&ROUND(MOD(CONVERT(F6,"kg","lbm")/14,1)*14,0)&"lb"

I used the formula below, given elsewhere on this site to convert kilos into
Stones & Pounds.

=INT(CONVERT(F6,"kg","lbm")/14)&"st "&MOD(CONVERT(F6,"kg","lbm")/14,1)
*14&"lb" When I converted 98 kilos I got the following result 15st 6.
05304563975091lb. Could someone advise how I can amend the formula to round
up or down the decimals so that the result would show 15st 6lb.

 

[ChrisSwatton via OfficeKB.com]

All the above works great. Thanks top everyone for thier assistance.

=INT(CONVERT(F6,"kg","lbm")/14)&"st
"&ROUND(MOD(CONVERT(F6,"kg","lbm")/14,1)*14,0)&"lb"

I used the formula below, given elsewhere on this site to convert kilos
into

[quoted text clipped - 5 lines]

round
up or down the decimals so that the result would show 15st 6lb.