Stones,Pounds and Ounces

C

Carole

Is there a "simple" way to add up Stones, Pounds and Ounces? I have tried
using three columns, one for each then dividing the total of the Llbs by 14
and Ozs by 16 but cannot get the end figure to show correctly. i.e the final
figure may be shown thus: 36.625
Help please
Carole
 
B

Bob Phillips

Assuming
Stones in K1:K5
Pounds in L1:L5
Ounces in M1:M5

=SUM(K1:K5,INT(SUM(L1:L5)/14))&"
Stones"&MOD(SUM(L1:L4,INT(SUM(M1:M5)/16)),14)&" Pounds
"&MOD(SUM(M1:M5),16)&" Ounces"

--

HTH

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

Bob Phillips

Whichever one you want, other than the cells being referred to.

--

HTH

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

Carole

Got that...it works
Thank you Bob
Carole

Bob Phillips said:
Whichever one you want, other than the cells being referred to.

--

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

Pounds to ounces 3
How do i format a number into stones, pounds and ounces, please? 5
Formatting a cell in stones and pounds 1
Using weight (pounds/ounces) in Access database 1
Convert Kilo's to pounds and ounces 4
adding pounds and ounces 8
How do I format cells to accept stones and pounds? 3
How can I add pounds and ounces in excel, 3

Top