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.
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.