How do a kg to stone convertion in excel
 

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

How do a kg to stone convertion in excel
 

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.
--
Greetings from New Zealand


"Michael Eastwood" <Michael wrote in
message ...
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

How do a kg to stone convertion in excel
 

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Michael Eastwood" <Michael wrote in
message ...
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

How do a kg to stone convertion in excel
 

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

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

OK

FLKulchar
"Bill Kuunders" wrote in message
...
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.
--
Greetings from New Zealand


"Michael Eastwood" <Michael wrote in
message ...
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

How do a kg to stone convertion in excel
 

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

FLKulchar
"Bernard Liengme" wrote in message
...
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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Michael Eastwood" <Michael wrote in
message ...
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