Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sum by coding | New Users to Excel | |||
How to fix the coding? | Excel Worksheet Functions | |||
How to fix the coding? | Excel Worksheet Functions | |||
coding | Excel Discussion (Misc queries) | |||
Coding | Excel Discussion (Misc queries) |