Forum Discussion

trina whittleton's avatar
trina whittleton
Copper Contributor
Feb 08, 2018

need help with excel

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.

 

  • Tinn Keeper's avatar
    Tinn Keeper
    Brass Contributor
    Hi,
    You could use MOD( ). In your example, =IF(MOD(F11;5)=0;F11;0)

    Kr
    TK

Resources