Stones,Pounds and Ounces

  • Thread starter Thread starter Carole
  • Start date Start date
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
 
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)
 
Whichever one you want, other than the cells being referred to.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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...
 
Back
Top