| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
