Re: Kilos to Stones & Pounds

Giganews Newsgroups
Subject: Re: Kilos to Stones & Pounds
Posted by:  MH (now…@nohow.co.uk)
Date: Sat, 6 Jan 2007

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

MH

"Chris Swatton" <u30739@uwe> wrote in message news:6be4267a95d0b@uwe...
>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

In response to

Kilos to Stones & Pounds posted by Chris Swatton on Sat, 06 Jan 2007