calculateanddeduct.xlsx (11.5 KB)
I work in a machine based casino, we’ve been having problems with our cash(out) machine and may have to go back to manually paying customers, I created a spreadsheet for past circumstances but it requires a bit of user input and some errors were made by staff.
I was wondering if it was possible to have a formula that calculates how much of each denomination to give but also deducts those amounts from a set value?
If not enough of one denomination is available, use other values.
For example:
Owed 250, give 240 in 20s, 10 in 10s.
Deduct these from the float value amounts that is set by the user
I’ve attached a spreadsheet which I hope makes a little more sense.