Forum Discussion
Jenoliv9
Oct 08, 2019Copper Contributor
Help!Calculation of daily meals without knowing dates and without exceeding daily amount of 550DKK
Hello Excel gurus, I need help in creating a formula, that for me is very complex. So I start by explaining how the policy is: Our employees are only entitled to get a daily meal allowance of 5...
tauqeeracma
Oct 08, 2019Iron Contributor
HIJenoliv9
As per my understanding first you need unique dates from a list of given dates and also sum of amounts against each unique date. And If this sum is more than 550 you want to reimburse the differential or zero otherwise.
I have tried to translate given scenario with the help of helper column in attached sample file, please let me know if it helps you.
Thanks
Tauqeer