Converting weight measurements

kelly1

Well-known Member
Joined
May 11, 2003
Messages
525
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
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

joelnichols

Active Member
Joined
Apr 13, 2004
Messages
384
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

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
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

Well-known Member
Joined
May 11, 2003
Messages
525
Sorry I haven't replied sooner I've been out all day

Thanks for the help

Kelly
 

Watch MrExcel Video

Forum statistics

Threads
1,118,025
Messages
5,569,720
Members
412,289
Latest member
Kingchaos64
Top