convert kilograms to stones AND pounds
Thanks Sandy
Typo on the 10
Not sure what you mean by the second part.
Gord
On Mon, 27 Oct 2008 23:55:12 -0000, "Sandy Mann"
wrote:
Gord,
=INT(A3*0.071429)&" Stones "&ROUND((A3*0.071429-INT(A3*0.071429))*10,0)&"
lbs"
Should you not have multiplied by 14 instead of 10? (Unless of course
Canada has metric stones <g)
and would it not be better to divide by 14 then multiply by 0.071429?
|