Convert stones and lbs to kg

**thommo14** · 02-17-2010, 11:11 PM

G'day guys,

Pretty much a novice when it comes to Excel, but I'm hoping you can help me out here.

What I want is to enter my weight in stones and pounds into one cell, then in another cell have that converted to kgs so I can display a chart.

I've tried a few things, but nothing working thus far. Any suggestions greatly appreciated!

Thanks,
Thommo

**shg** · 02-17-2010, 11:16 PM

If A1 contains stones abd B1 pounds, =A1*6.35 + B1*0.454

**teylyn** · 02-17-2010, 11:18 PM

Hi Thommo,

how would you enter stones and pounds into one cell? I'm not familiar with the imperial system, so I don't know how that will be expressed in decimals. But if you have stones in A1 and pounds in B1, and if I'm not mistaken, there are 14 pounds in a stone, you can use

=convert((A1*14)+B1,"lbm","g")/1000

does that help?

**thommo14** · 02-17-2010, 11:24 PM

Hi guys,

Many thanks for the speedy replies. What I'm trying to achieve is basically the reverse of this:

http://www.excelforum.com/excel-new-...nd-pounds.html

Thanks,
Thommo

**teylyn** · 02-17-2010, 11:36 PM

Can you explain what your input will be? Maybe in an example file?

**thommo14** · 02-17-2010, 11:43 PM

A1 = 10 (stone)
B1 = 10 (lbs - not sure how halves or fractions would work here)
C1 = Conversion to kg

Hope this helps,
Thommo

**teylyn** · 02-17-2010, 11:45 PM

So, what more do you need? There are two suggestions already.

**thommo14** · 02-17-2010, 11:56 PM

Okay, stay with me here (numbers isn't my strong point).

The conversion throws up a slightly different result than the following web site's converter:

http://www.ukmicentral.nhs.uk/resour...onvert=Convert

Any ideas? (I'm entering 10 for both stone and pounds.)

Cheers,
T

**teylyn** · 02-18-2010, 12:34 AM

Well, AFAIK

1 pound = 0.45359237

so 10 stone = 140 lb
and 10 stone 10 lb = 150 lb
so 150*0.45359237 = 68.0388555
rounded to 68.04

That's the result I get in several other web calculators, the result that shg's formula delivers and the result that my suggestion delivers. I'd wager the NHS have it wrong or they're using slightly heavier pounds

.