I have random numbers in my excel sheet, in a particular cell, I want the last value from Column A printed ? What would be the formula for that?

My current I have tried applying formulas like :- =IF(F:F<=240,(A2:A101<=240),0) or =IF(F:F<=240,MAX(A2:A101<=240),0) but could not get anything.