I am trying to make a spreadsheet for nightly cashout that enables staff to input the quantity of each currency and automatically gives them the quantity of each currency into the deposit bag. However I am stuck on a certain area where we go from coins to bills. as you can see in the image I have 195(this number is going to be changing on a daily basis) running total up to the 2.00. this is where I am getting stuck. seeing as it is a multiple of 5 I want it to just go to the next line, however if it is less than 5 I want it to round to the next lowest multiple of 5, and if it is greater than 5 then I want it to take it down to the next lowest 5 and put the left over amount into the rows below. I know I can use an ifs statement but am having issues writing " ifs(f11= multiple of 5, f11). Any help would be great.
