Geez

I saw the "domination" and thought this will be an interesting post.

Got me all excited<g


Gord Dibben MS Excel MVP

On Tue, 3 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