Kilos

[Walshy]

Hi,

Is there a function or a quick way of coverting kilos into Stones and
pounds?

Thanks

 

[Andy Wiggins]

From the Help file:
=CONVERT(1.0, "lbm", "kg") Converts 1 pound mass to kilograms
(0.453592)

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

So you need:
=CONVERT(1,"kg","lbm")

.... then divide by 14 to get stones

 

[Kevin James]

If the kilos are in cell A1, then this in cell B1

=TEXT(A1/0.453592/14,"00")&" Stone - "&TEXT(MOD(A1/0.453592,14),"00")&" lbs"

HTH
--
Kevin James.
Tua'r Goleuni


| Hi,
|
| Is there a function or a quick way of coverting kilos into Stones and
| pounds?
|
| Thanks
|
|
|