Just for the sake of nostalgia I played with adding three LSD amounts.
Method 1
item £ s d
a 1 18 9
b 2 3 4
c 4 12 5
sum 8 14 6
D5 (pennies) =MOD(SUM(D2:D4),12)
C5 (shillings) =MOD((SUM(C2:C4)+INT(SUM(D2:D4)/12)),20)
B5 (pounds) =SUM(B2:B4)+INT((SUM(C2:C4)+INT(SUM(D2:D4)/12))/20)

Method 2
item £ s d = pence
a 1 18 9 = 465
b 2 3 4 = 520
c 4 12 5 = 1109
total 8 14 6 = 2094
In F2 (under 'pence' ) =B2*240+C2*12+D2
This is copied to F3 and F4
In F5 =SUM(F2:F5)
D5 (pennies) =MOD(F5,12)
C5 (shillings) =MOD((F5-D5)/12,20)
B5 (pounds) =INT(F5/240)
This method is useful if ,for example, you want 12% of the sum; just change
F5 to =SUM(F2:F5)*12%

hope some of this helps
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme




"peter" wrote in message
...
I want to use pounds shillings and pence format in excel...is it possible
and
if so how do I go about it?