Formula for Converting Kilos to Stones

P

Paulf

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Formula (stones and pounds to kg's) 1
WEIGHT CONVERSION??? 3
A few problems involving LOOKUP and SUMPRODUCT... 2
Searching the formula (not the value) for a text string 1
Weight convertor 3
Help with a formula involving 3 columns 11
Convert Lbs to Stones and Lbs 2
Cumulative formula for word table 0

Top