Deebee

06-11-2002, 12:57 AM

I'm a historian, and would like to sometimes play with old invoices, cashbooks etc. in Excel 95, keeping the amounts in their original figures.

After playing with a whole lot of nested TRUNCs, MODs SUMs and divisions by 12 and 20, I got the following addition to work:

2 . 3 . 4

30 . 15 . 8

13 . 8 . 1

17 . 6 . 3

5 . 0 . 7

£68 . 13 . 11

(oops PressF1 drops out spaces) but after changing all the figures to negatives with a minus sign, I got -£68. 7. 1, and haven't a clue how. I can do such sums in my head much faster than I can make Excel do it.

If only Willie Gates and his crew had of thought of this. Someone probably cracked the problem long ago, but a few hours of Googling didn't enlighten me, and I still have to include the halfpennies and farthings. Multiplications and divisions must be diabolically difficult.

Any hints?

By the way, I've done a spreadsheet which converts £/s/d & farthings and NZ$/c in any decade from 1270 and year from 1800 to its 2001 NZ$ equivalent if anyone's interested in a copy.

E.g. £28.17.4½ in 1837 sterling = NZ$3,130.28 in 2001.

After playing with a whole lot of nested TRUNCs, MODs SUMs and divisions by 12 and 20, I got the following addition to work:

2 . 3 . 4

30 . 15 . 8

13 . 8 . 1

17 . 6 . 3

5 . 0 . 7

£68 . 13 . 11

(oops PressF1 drops out spaces) but after changing all the figures to negatives with a minus sign, I got -£68. 7. 1, and haven't a clue how. I can do such sums in my head much faster than I can make Excel do it.

If only Willie Gates and his crew had of thought of this. Someone probably cracked the problem long ago, but a few hours of Googling didn't enlighten me, and I still have to include the halfpennies and farthings. Multiplications and divisions must be diabolically difficult.

Any hints?

By the way, I've done a spreadsheet which converts £/s/d & farthings and NZ$/c in any decade from 1270 and year from 1800 to its 2001 NZ$ equivalent if anyone's interested in a copy.

E.g. £28.17.4½ in 1837 sterling = NZ$3,130.28 in 2001.