Hi guys,

I am trying to understand how to overcome this problem that I have been struggling with.

So there is a certain amount (say, $1000) post which I have an additional transaction charge (per $, say 50 cents). And say, every month I have a certain spend (which depends on formulas so, not fixed). I have a column for "additional charge" which essentially has to check for each month whether it crosses the 1000 threshold (annual) and then apply the per $ charge to the cell. Now I tried using an "if" command, which works. But the challenge is that, once in any particular month (or cumulatively till that month) the amount spent crosses $1000, I have to account for the per $ charge. But the very next month (assuming it is still in the same year) will not have any more bandwidth for the $1000 limit left. So the entire charge on that month will be above the $1000 threshold so will be charged on that per $ basis.

So, for now, I have been adding these formulae manually once the $1000 limit crosses. But I would like for a formula/ something where it checks 2 things, whether the spend has cumulatively crossed $1000 and whether that $1000 deduction has already been taken into account in the previous month. Hope this makes sense and you guys can help me out with it!!