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

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

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

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