Doing historical research, it would be good if I could enter duodecimal
currency values in a spreadsheet that could then be manipulated; anybody have
any ideas how I might do that?

Thanks

Pete

See:

http://groups.google.com/group/micro...19fad009e36e25
--
Gary''s Student - gsnu200834


"Doverboat" wrote:

Doing historical research, it would be good if I could enter duodecimal
currency values in a spreadsheet that could then be manipulated; anybody have
any ideas how I might do that?

Thanks

Pete

Or enter "pounds shillings" keywords in General questions Search field and
see Jim Rech's post.
Regards,
Stefi


€žGary''s Student€� ezt Ã*rta:

See:

http://groups.google.com/group/micro...19fad009e36e25
--
Gary''s Student - gsnu200834


"Doverboat" wrote:

Doing historical research, it would be good if I could enter duodecimal
currency values in a spreadsheet that could then be manipulated; anybody have
any ideas how I might do that?

Thanks

Pete

To add my two tuppence worth. data below

A B C D
£ s d
7 2 10 6
8 3 14 9
6 5 3

11 £ s d
12 3 15 4
13 4
15 1 4

B9: =SUM(B7:B8)+INT(SUM(C7:C8)/20)
C9: =MOD(SUM(C7:C8),20)+INT(SUM(D7:D8)/12)
D9: =MOD(SUM(D7:D8),12)

B14: =B12*D13+INT(D13*C12/20)
C14: =MOD(D13*C12,20)+INT(D12*D13/12)
D14: =MOD(D12*D13,12)

Alternatively, for multiplication use a helper cell to calc in decimal.

=(D13*D12+(D13*C12*12)+D13*B12*240)/240

And convert to lsd
="£"&TEXT(INT(E16),0)&" "&INT(MOD(E16,INT(E16))*20)&"s
"&TEXT(MOD((MOD(E16,INT(E16))*240),12),0)&"d"

Regards
Peter

"Doverboat" wrote:

Doing historical research, it would be good if I could enter duodecimal
currency values in a spreadsheet that could then be manipulated; anybody have
any ideas how I might do that?

Thanks

Pete