Can I enter old-fashioned pounds, shillings and pence in Excel?

D

Doverboat

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
 
S

Stefi

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


„Gary''s Student†ezt írta:
 
B

Billy Liddel

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
 

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

I wish to enter pounds shillings and pence in sterling 1
pounds shillings pence format in excel 2
How do I add Pounds, Shillings and Pence? 1
How to enter pre-decimal pounds shillings pence in Excel workshee 5
Pre Decimal Currency - Calculations in Excel 12
Currency Rounding and Splitting Pounds and Pence 9
How do I format a cell to show weight in stones and pounds? 2
Query Formula (stones and pounds to kg's) 1

Top