I need help getting excel to take the new amount and in the four columns split that amount into dollars needed it could say 4 or 400 or 400.00 that doesn't matter. I am not that good at formulas like this. below is an example of my worksheet. When I post this the columns don't line up.
PrevBonus Add New 100's 50's 20's 5's needed
25.00 25.00 50.00 0 1 0 0
125.00 25.00 150.00 1 0 1 1
475.00 25.00 500.00 4 1 1 1
150.00 25.00 175.00 1 1 0 0
50.00 25.00 75.00 0 1 0 0
175.00 25.00 200.00 1 1 1 1
75.00 25.00 100.00 0 1 1 1
25.00 25.00 50.00 0 0 1 1
375.00 25.00 400.00 3 1 1 1
Total Bills 10 7 17 6
new$Formula=Prev+add Totals Bills for 100/50/20/05 are sum formulas
PrevBonus Add New 100's 50's 20's 5's needed
25.00 25.00 50.00 0 1 0 0
125.00 25.00 150.00 1 0 1 1
475.00 25.00 500.00 4 1 1 1
150.00 25.00 175.00 1 1 0 0
50.00 25.00 75.00 0 1 0 0
175.00 25.00 200.00 1 1 1 1
75.00 25.00 100.00 0 1 1 1
25.00 25.00 50.00 0 0 1 1
375.00 25.00 400.00 3 1 1 1
Total Bills 10 7 17 6
new$Formula=Prev+add Totals Bills for 100/50/20/05 are sum formulas