# Pounds to stones in Excel

graham√ 10:42 08 Jun 03
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 03

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 03

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 03

1 pound = .4536 kilograms.Go for it!

graham√ 11:39 08 Jun 03

Thankyou, I knew you would come up trumps!

VoG™ 11:40 08 Jun 03

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

graham√ 11:43 08 Jun 03

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

graham√ 12:00 08 Jun 03

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 03

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 03

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.

Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

This poetic animation about monsters is illustrated in a Van Gogh painterly style

Apple predictions 2017