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

Google Home Hub review

50 Cent is Iron Man in these comic book cover reissues of hip hop classics

How to watch Apple’s October 2018 iPad launch

Mac : comment forcer la fermeture d’une application ?