Sample.xlsx

Thanks and apologies I should have thought of that.

The results I am seeking are for the time related cells to zero out once they pass their expiry or break date but also to display the word "VOID" when this is the case. Once there has been a consecutive number of "VOID" periods determined by the VOID cell I want the subject cell to revert back to the initial formula of the "Rent" amount divided by 4.

I appreciate this is somewhat convoluted and if it's not possible I completely understand.

Thanks