convert kilograms to stones AND pounds
This formula will give you stones and pounds from Kg
=INT(A3*0.071429)&" Stones "&ROUND((A3*0.071429-INT(A3*0.071429))*10,0)&"
lbs"
Gord Dibben MS Excel MVP
On Mon, 27 Oct 2008 15:44:01 -0700, Bristlepete
wrote:
Converting Kilograms to Stones is straight forward but is it possible to
take the part of the number after the decimal point and convert it to pounds?
|