Excel Forum



Mr Excel & excelisfun Trick 30: Count Bills for Money Transaction


See Mr Excel and excelisfun create formula that will take a dollar amount and count how many $100 bills, how many $50 bills, etc. are needed for the minimum number of bills to be used. See the INT, SUMPRODUCT and QUOTIENT functions.





Got a Question? Ask it Here in the Forum.