I do not use spreadsheets often, so I am certainly a novice. I want to be able to convert Kilograms to Stones, Pounds and Ounces.
The formula I’m trying to adapt only shows Stones and Pounds and I’m trying to understand the various steps so that I might add the ounces.
This is the formula: =IF(A13="","",IF(ROUND(MOD(A13*2.203,14),0)=14,ROUNDDOWN(A13*(2.203/14),0)+1&" st 0 lbs",ROUNDDOWN(A13*(2.203/14),0)&" st "&ROUND(MOD(A13*2.203,14),0)&" lbs"))
Breaking the whole down
In the nested ‘IF’ function it would seem to be saying that the TEST would be that the remainder of the product of A13*2.203 divided by 14 and rounded to zero digits after the dec.point would equal 14.
The only numbers I can get a ‘TRUE’ reading are: 38 ; 57 ; 108 ; 127 ( in the range 35 – 135Kgs) yet none of these numbers = 14 after applying the test.
I know its not a coincidence that there are 14 pounds in a stone but I can’t make the connection. Any help would be appreciated and if I’m in the wrong category I apologise.
Bookmarks