Forum Discussion
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. Howeve...
Hi,
You could use MOD( ). In your example, =IF(MOD(F11;5)=0;F11;0)
Kr
TK
You could use MOD( ). In your example, =IF(MOD(F11;5)=0;F11;0)
Kr
TK