LATEST VALUE

[apgmin]

M0NTHLY DUE DATE	AMOUNT PAID		PRINCIPAL BALANCE
28-Feb-21​			126276.16​
28-Mar-21​	9000​		123276.16​
28-Apr-21​			129572.05​
28-May-21​	50000​		85877.81​

Hello All, Please help

I have put in cell F3, =today()

In the monthly due date I have put =edate(upper cell+1)

Now in cell f4, I want the current principal balance like 85877.81 as pon today but 129572 after 28 april

or else tell me a way to get the value in the last cell in the column ( currently 858777.81) in cell f4, like if the cell ( currently 858777.81) would had been blank then the results should be 129572.05 in cell f4

 

[apgmin]

=LOOKUP(2,1/(P2:P61<>""),P2:P61)

 

[Peter_SSs]

For any future questions, you might keep in mind that we cannot see your worksheet so describing what is in what cell/column etc without telling us what columns and rows you have shown makes it very hard for us to set up a worksheet to test.

Given that, if your column P is filled with numbers and/or null strings (""), you could reduce the calculation burden of trying to divide all the cell values with this instead

=LOOKUP(9.99E+307,P2:P61)