How do a kg to stone convertion in excel

[Michael Eastwood]

I tried doing a v lookup for a kg to stone/pound convertion. The problem
arrises because there is 14 lbs to a stone. Excel dosent recoznise 1 stone
12 lbs for example

 

[Bill Kuunders]

Googled for this one..........

=INT(A3*0.071429)&" Stones "&ROUND((A3*0.071429-INT(A3*0.071429))*10,0)&"
lbs"

enter the kg's in A3
You can work with the rounding if you need part pounds.

 

[Bernard Liengme]

As an alternative to Bill's answer
A3 has weight in kilograms
=A3*0.071429
then format with Custom format # ??/14
In this way, 100 kg displays as 7 2/14 meaning 7 stone 2 lbs
best wishes from Canada

 

[FLKulchar]

There is one slight mistake in the above formula...

Thge "*10.0" (times 10) must be changed to "*14.0" (times 14) !!!

OK

FLKulchar

 

[FLKulchar]

another error on my part...change the 10,0 to 14,0

FLKulchar