Convert Lbs to Stones and Lbs

D

Dale

Hi, I am trying to construct a ss that will keep track of weight while on a
diet. I want to be able to insert a weight reading in Pounds, and have
Excel convert it to Stones and Pounds . If I do a straight forward divide
by 14, then I get the wrong answer i.e., 15lbs divided by 14 = 1.0714 - I
would like it to read 1st 1lb. Is this possible?
 
B

Bob Phillips

Here is a formula

=INT(A1/14)&" st "&MOD(A1,14)&" lb"

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
D

Dale

Thanks Bob, that worked just fine
Dale


Bob Phillips said:
Here is a formula

=INT(A1/14)&" st "&MOD(A1,14)&" lb"

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 

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

Can I convert Imperial lbs to Stones and lbs in the same cell? 1
How do I convert pounds to stones eg 200 pounds is 14 stone 4 lb 4
How to format in stones & pounds and then present on chart 2
A few problems involving LOOKUP and SUMPRODUCT... 1
convert kilograms to stones AND pounds 9
how do i use excel to calculate weight (as in stone and lbs)? 6
How do i format a number into stones, pounds and ounces, please? 5
how can i use imperial units eg stones and pounds 2

Top