[deleted by user]
[removed]
[{"id": "hiqaah2", "text": "If your year cell equals the cell in the previous cell then zero, else whatever your fee is. \n\n=if(B3=A3,0,leasing fee)\n\nSo when it turns from year to year 1, you will get the fee, then when year 1 turns to year 2 ect", "replies": [{"id": "hirjmak", "text": "This, but I would add  (year &lt;=5) * (your solution) in case model goes beyond 5 years. That way OP doesnt have to hardcode a stop.", "replies": [{"id": "hirom80", "text": "Good catch, my original would work for all years and op only wanted the first five.", "replies": [{"id": "hisc6sr", "text": "Happy to add. Super simple solution but bane of my existence till I figured out a strat for it.", "replies": [], "depth": 4}], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "hir6dam", "text": "I fear your model may be too basic to handle that after looking at the image posted. That said, depending on what you are trying to get this to line up for, I am guessing NOI or GPI - you could just subtract one month rent payment from the overall revenue line annually.", "replies": [{"id": "hirl4sp", "text": "The model is fine. Look at the solution the other user posted. OP already has monthly income and just needs a way to catch true/false the dates so they can multiply by the dollar amount needed. False x amount will zero out and true will show the dollar amount in period", "replies": [], "depth": 2}], "depth": 1}]