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

See my previous thread click here

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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

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

Best Christmas Agency Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…