# Pounds to stones in Excel

graham√ 10:42 08 Jun 2003
Locked

I would like to convert pounds in one column to stones, pounds and ounces in three other columns. The pounds are to one decimal place, around the 180 mark (I'm very tall!). I can confirm there are 14 pounds to 1 stone, and 16 ounces to 1 pound.

Pesala 11:25 08 Jun 2003

I would like to convert kilos to pounds on my bathroom scale, but I spend so much time at the computer that I don't get enough exercise.

VoG™ 11:35 08 Jun 2003

With Pounds in A2

In B2 =ROUNDDOWN(A2/14,0)

In C2 =ROUNDDOWN(A2-14*B2,0)

In D2 =16*(A2-INT(A2))

graham√ 11:36 08 Jun 2003

1 pound = .4536 kilograms.Go for it!

graham√ 11:39 08 Jun 2003

Thankyou, I knew you would come up trumps!

VoG™ 11:40 08 Jun 2003

=CONVERT(A2, "lbm", "kg")

graham√ 11:43 08 Jun 2003

Sorry, I was answering Pesala, but that will be saved as well!

graham√ 12:00 08 Jun 2003

Just to show I'm paying attention, when I apply the formula to a list in A, the stones and pounds convert when I drop down the list, but the ounces do not convert, they just copy D2. Does this need a refinement, please?

VoG™ 12:05 08 Jun 2003

Check that you've copied the firmula down the column correctly. For row 6 (e.g.) the formula should be

=16*(A6-INT(A6))

graham√ 12:14 08 Jun 2003

Thanks, OK now. When I copied and pasted it left the second ) off somehow.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best Black Friday Deals 2017

How modern book design was influenced by illustrated manuscripts

Best Black Friday Apple Deals 2017

Les meilleurs logiciels de montage vidéo gratuits (en 2017)