Hi guys

I am trying to make a tip sheet with a function that tells you whether I need a change or not.

If I enter how much we have for each bills($1bill, $5bill, etc), is it possible for an excel to tell me whether I have enough small bills to be able to distribute all cash to given number of employees?

For ex. if we have only $100.00 bills, it's no brainer that we need a change, but if we have mixture of everything, sometimes it's hard to know in the beginning. it'd be great if it's possible for an excel to tell you which bills to give each employee exactly.

Thank you!