How do I add Pounds, Shillings and Pence?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to computerise old accounting records in pounds, shillings and
pence,and display the result in the same way. How do I add colums of figures
and get the correct "carry over" into the next colum, bearing in mind there
were 12 pennies in one shilling and 20 shillings in one pound?
 
Assume the pounds in A1:A5, shillings in B1:b5, pence in C1:C5

A6: =SUM(A1:A5,INT(SUM(B1:B5)/20
B6: =MOD(SUM(B1:B5,INT(SUM(C1:C5)/12)),20)
C6:=MOD(SUM(C1:C5),12)

--

HTH

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