How do I convert pounds to stones eg 200 pounds is 14 stone 4 lb
 

I have a table of weights, in pounds. How do I convert them to stones and
pounds in excel. I dont want to say 14.5 stomes, I want to say 14 stones 7
pounds.
Thanks

How do I convert pounds to stones eg 200 pounds is 14 stone 4 lb
 

Hi,

With pounds in a1 try this

=INT(A1/14) & " Stones " & MOD(A1,14)&" Pounds"

Mike

"J" wrote:

I have a table of weights, in pounds. How do I convert them to stones and
pounds in excel. I dont want to say 14.5 stomes, I want to say 14 stones 7
pounds.
Thanks

How do I convert pounds to stones eg 200 pounds is 14 stone 4 lb
 

Try this:
=TRUNC(A1/14) & " STONES " & ROUND(SUM(11/14,-TRUNC(11/14))*14,0) & " POUNDS"
Micky


"J" wrote:

I have a table of weights, in pounds. How do I convert them to stones and
pounds in excel. I dont want to say 14.5 stomes, I want to say 14 stones 7
pounds.
Thanks

How do I convert pounds to stones eg 200 pounds is 14 stone 4
 

11 should read: A1
Anyhow, Mikes formula is "nicer"
Micky


Try this:
=TRUNC(A1/14) & " STONES " & ROUND(SUM(11/14,-TRUNC(11/14))*14,0) & " POUNDS"
Micky


"J" wrote:

I have a table of weights, in pounds. How do I convert them to stones and
pounds in excel. I dont want to say 14.5 stomes, I want to say 14 stones 7
pounds.
Thanks

How do I convert pounds to stones eg 200 pounds is 14 stone 4
 

Micky,

I bet you meant this :)

=TRUNC(A1/14) & " STONES " & ROUND(SUM(A1/14,-TRUNC(A1/14))*14,0) & " POUNDS"

But I'd still go with my shorter version.

Mike

"מיכאל (מיקי) אבידן" wrote:

Try this:
=TRUNC(A1/14) & " STONES " & ROUND(SUM(11/14,-TRUNC(11/14))*14,0) & " POUNDS"
Micky


"J" wrote:

I have a table of weights, in pounds. How do I convert them to stones and
pounds in excel. I dont want to say 14.5 stomes, I want to say 14 stones 7
pounds.
Thanks