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.
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?