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.

  graham√ 11:36 08 Jun 2003

See my previous thread click here

1 pound = .4536 kilograms.Go for it!

  graham√ 11:39 08 Jun 2003

Thankyou, I knew you would come up trumps!

  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?

  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

Samsung Galaxy Fold review: Hands-on

Best Wacom deals for Easter

iMac 21.5in (2019) review

Comment faire pivoter une vidéo ?