(Msg. 1) Posted: Sun Dec 23, 2007 1:51 pm
Post subject: How do a kg to stone convertion in excel Archived from groups: microsoft>public>excel>misc (more info?)
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
(Msg. 2) Posted: Sun Dec 23, 2007 10:22 pm
Post subject: Re: How do a kg to stone convertion in excel [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" 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
(Msg. 3) Posted: Sun Dec 23, 2007 10:22 pm
Post subject: Re: How do a kg to stone convertion in excel [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" 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
>
>
(Msg. 4) Posted: Mon Dec 24, 2007 3:00 am
Post subject: Re: How do a kg to stone convertion in excel [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
enter the kg's in A3
You can work with the rounding if you need part pounds.
--
Greetings from New Zealand
"Michael Eastwood" 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
(Msg. 5) Posted: Mon Dec 24, 2007 3:00 am
Post subject: Re: How do a kg to stone convertion in excel [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" 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
>
>
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in
Office