Neat, works for row 2, but needs a tweak/edit for rows 3 onwards

It needs $1's in the $B1:B1
ie =IF($A2="","",INT(($A2-SUMPRODUCT(($B2:B2)*($B$1:B$1)))/C$1))

Steve

On Tue, 03 Oct 2006 23:54:21 +0100, Roger Govier
wrote:

Hi Bec

Depending upon the country you are in you may have to change the values
you enter in row 1 of your table.
For the UK I set up as follows
In cells B1:M1
50, 20, 10, 5, 2, 1, 0.50, 0.20, 0.10, 0.05, 0.02, 0.01
In cell A2 I entered the first salary
in cell B2
=IF($A2="","",INT($A2/B$1))
in cell C2
=IF($A2="","",INT(($A2-SUMPRODUCT(($B2:B2)*($B1:B1)))/C$1))
Copy C2 across through D2:M2
Copy B2:M2 down the page as far as you require