Hi all,
I am calculating a loan repayment. I have a set of data that eventually equals zero. I want a cell that will tell me at what time this happens.
So, I have a set of values in Column L, it eventually reached 0, I have a time vale in column G, it increases by 1 each cell. I want a formula that says when the first value in column L is less that or equal to 0, display cell G that is in the same row. I can't figure out how to do this though. Can anyone help please?