View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Anna Anna is offline
external usenet poster
 
Posts: 132
Default Need help with coding

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