Kilos to Stones & Pounds

  • Thread starter Thread starter Chris Swatton
  • Start date Start date
C

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.
 
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.
 
=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)
 
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.
Click to expand...
 
All the above works great. Thanks top everyone for thier assistance.

Bob said:
=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
Click to expand...
[quoted text clipped - 5 lines]
round
up or down the decimals so that the result would show 15st 6lb.
Click to expand...
Click to expand...
 
Back
Top