title: Need excel formula to deduct $100 from total sales, breakdown the $100 in bills/coins, then breakdown the remaining balance as well
body: <p>Using this websites help (<a href="https://exceljet.net/formula/cash-denomination-calculator" rel="nofollow noreferrer">https://exceljet.net/formula/cash-denomination-calculator</a>) i was able to figure out how to breakdown the cash in my register into bills and dollars. The problem is, the formulas calculate imaginary numbers, not actual bills or coins that exists in my register. It will tell me I need a $50 bill, when i don't actually have one.</p>
  
  <p>Please look at the attached image. I expect the formula to calculate (breakdown) how many 100,50,20,10,5,1 dollar bills &amp; 1 dollar coins, 50 cent coins, quarters, dimes, nickels, pennies i need to leave for next days $100 petty cash in the register and also how many bills/coins i need to give to accounting (as actual sales) also broken down. The formula would first need to deduct the petty cash and break that down. Then, whatever is left in the register, it would need to break down also. Breaking down the remaining sales would ensure we have a strict control of our money, and would help identify any lost bills/coins. I hope the attached picture makes it easier to understand what i'm trying to do.</p>
  
  <p>FYI, I haven't used VBA Code, But i am very open to the idea.</p>
  
  <p><a href="https://i.stack.imgur.com/LKQZA.jpg" rel="nofollow noreferrer">Snapshot of excel sheet</a></p>