O
Odyssey 62
How do I format to show lb & stones eg 24lb = 1st 10lb
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
You can't do it by cell formatting.
=INT(A1/14)&"st "&MOD(A1,14)&"lb"
=INT(A1/14)&"st "&MOD(A1,14)&"lb"
M
Mike H
Hi,
I'm not sure about a format but with a number of pounds in A1 try this.
=INT(A1*0.0714286)&" St " &INT((A1*0.0714286-INT(A1*0.0714286))/0.0714286)&"
lbs"
It will start losing accuracy at around 2500000 pounds.
Mike
I'm not sure about a format but with a number of pounds in A1 try this.
=INT(A1*0.0714286)&" St " &INT((A1*0.0714286-INT(A1*0.0714286))/0.0714286)&"
lbs"
It will start losing accuracy at around 2500000 pounds.
Mike
D
David Biddulph
Dividing by 14 is better than muliplying by a rough approximation to the
reciprocal.
And for the remainder after the division, MOD(A1,14) is easier than
INT((A1*0.0714286-INT(A1*0.0714286))/0.0714286)
reciprocal.
And for the remainder after the division, MOD(A1,14) is easier than
INT((A1*0.0714286-INT(A1*0.0714286))/0.0714286)
M
Mike H
David,
When I saw your answer i couldn't believe I'd made such a simple thing so
complicated. Thanks.
Mike
When I saw your answer i couldn't believe I'd made such a simple thing so
complicated. Thanks.
Mike