| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data as Stone, pounds and ounces | Excel Discussion (Misc queries) | |||
| Convertion of excel to CSV format | Excel Discussion (Misc queries) | |||
| excel to text convertion | Excel Discussion (Misc queries) | |||
| Date convertion | Excel Discussion (Misc queries) | |||
| Convertion | New Users to Excel | |||
Linear Mode
