Automatic calculation for multiple $ denominations in 1 cell

I am pretty new to using excel. I am trying to create a spreadsheet for my finances. I am going to make a budget and I am planning on going to the bank each week and taking out a certain amount of bills. For example if my Gas is $75, I will need to take out 3-$20's, 1-$10 and 1-$5 to make up the $75. I want to put these amounts next to the total amount of the bill and then figure out a way to have the excel automatically calculate the column to show me at the end of the budget how many $20's, $10's and $5's I will need to take out. Is there a way to create an equation that can differentiate the different denominations like this?

bassman1

Welcome to Exceltip forum

Please take a couple of minutes and read ALL the Forum Rules then edit your thread title by following the instructions in the rules (Rule 1) so that it better discribes your problem/request

waiting to change title

waiting to change title

bassman1

Your new title still fails to meet forum rules

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!