Converting weight measurements

[kelly1]

I need a formula to convert kilograms to stones, pounds and ounces.

For the benefit for people outside of the UK, there are 16 ounces in a pound, and 14 pounds in a stone.


Thanks for any help

Kelly

 

[joelnichols]

You want a break down of each unit or of a total? Like...


1000kg = 2204.623 lb, or 35273.972 ou, or 157.4730653 stones?

 

[DominicB]

Good morning kelly

Go to Tools > Add-Ins and select Analysis ToolPak.

Not much will seem to have happened, but you'll have a new function (amongst other things) in your arsenal called CONVERT.

If you have your kilos (1000) in A1, then this formula in A2 will return 2204.623 (pounds):

=CONVERT(A1,"g","lbm")*1000

If you want to show it in stones and pounds (and remember that this looks better but you will lose "addibility") then put this formula in A3:

=ROUND((A2/14),)&" Stones and "&ROUND(MOD(A2,14),)&" pounds"

You could take it even further to show ounces but you get the idea.

HTH

DominicB

 

[kelly1]

Sorry I haven't replied sooner I've been out all day

Thanks for the help

Kelly