Kilos to Stones & Pounds

Giganews Newsgroups
Subject: Kilos to Stones & Pounds
Posted by:  Chris Swatton (u307…@uwe)
Date: Sat, 06 Jan 2007

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.

Replies