| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Converting Kilos to Stones
Hope you can help.
Is there a formula that will convert kilos into stones? I have tried the =CONVERT option, but hoped soneone would be able to show how to display "14 Stones & 4 Lbs" rather than 14.4.... Thanks in advance Paulf |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for Converting Kilos to Stones
Paul
=INT(A3*0.071249)&" Stones "&ROUND((A3*0.071249-INT(A3*0.071249))*10,1)&" lbs" OR =INT(A3*0.071249)&" Stones "&ROUND((A3*0.071249-INT(A3*0.071249))*10,0)&" lbs" Gord Dibben MS Excel MVP On Thu, 24 May 2007 17:34:57 GMT, "Paulf" wrote: Hope you can help. Is there a formula that will convert kilos into stones? I have tried the =CONVERT option, but hoped soneone would be able to show how to display "14 Stones & 4 Lbs" rather than 14.4.... Thanks in advance Paulf |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for Converting Kilos to Stones
Whoops!
Conversion factor for Kg is 0.157473, not 0.071249 Gord On Thu, 24 May 2007 11:28:10 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Paul =INT(A3*0.071249)&" Stones "&ROUND((A3*0.071249-INT(A3*0.071249))*10,1)&" lbs" OR =INT(A3*0.071249)&" Stones "&ROUND((A3*0.071249-INT(A3*0.071249))*10,0)&" lbs" Gord Dibben MS Excel MVP On Thu, 24 May 2007 17:34:57 GMT, "Paulf" wrote: Hope you can help. Is there a formula that will convert kilos into stones? I have tried the =CONVERT option, but hoped soneone would be able to show how to display "14 Stones & 4 Lbs" rather than 14.4.... Thanks in advance Paulf |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for Converting Kilos to Stones
Many thanks for your help!!
"Gord Dibben" <gorddibbATshawDOTca wrote in message ... Whoops! Conversion factor for Kg is 0.157473, not 0.071249 Gord On Thu, 24 May 2007 11:28:10 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Paul =INT(A3*0.071249)&" Stones "&ROUND((A3*0.071249-INT(A3*0.071249))*10,1)&" lbs" OR =INT(A3*0.071249)&" Stones "&ROUND((A3*0.071249-INT(A3*0.071249))*10,0)&" lbs" Gord Dibben MS Excel MVP On Thu, 24 May 2007 17:34:57 GMT, "Paulf" wrote: Hope you can help. Is there a formula that will convert kilos into stones? I have tried the =CONVERT option, but hoped soneone would be able to show how to display "14 Stones & 4 Lbs" rather than 14.4.... Thanks in advance Paulf |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format cells to accept stones and pounds? | Excel Discussion (Misc queries) | |||
| does anyone have a chart for weight gain or loss in kilos? | Excel Discussion (Misc queries) | |||
| how can i use imperial units eg stones and pounds | Excel Discussion (Misc queries) | |||
| Stones and Lbs | Excel Worksheet Functions | |||
| I've got a formula for stones and pounds - how do I get an excel . | Charts and Charting in Excel | |||
![Paulf[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
