One way. I have done this for a postage calculator.
$ 2,585.00 TOTAL
Using Variables in 1st column
100.00 =INT(D17/B17) =B15
50.00 =INT(D18/B18) =ROUND(MOD(D17,B17),2)
20.00 =INT(D19/B19) =ROUND(MOD(D18,B18),2)
10.00 =INT(D20/B20) =ROUND(MOD(D19,B19),2)
5.00 =INT(D21/B21) =ROUND(MOD(D20,B20),2)
1.00 =INT(D22/B22) =ROUND(MOD(D21,B21),2)
0.50 =INT(D23/B23) =ROUND(MOD(D22,B22),2)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"anna" wrote in message
...
I work for the company where we still pay the cash wages, before I go to
the
bank I Have to work out what how many hundreds fifties and so on to get ,I
set up on a spreadsheet
where I put the amount earn for example $2085 dollars and at this stage I
put manually how may hundreds ,fifties ,twenties ,tens and fives goes into
that sum is there a code so it can automatically do this for me in excel
2003
Can anyone help Thank you in advance

$100 $50 $20 $10 $5
$2,085 20 1 1 1 1
$1,975 19 1 1 1
$2,135