LOOKUP, IF formula problem

I need to retreive the value from the last non blank cell in a set of cells (not on the same row or column), so, I use this formula:



ok, the issue is: if I use : IF(L65>0,L65 …etc , everything works like a charm, but if I use the >= combination it turn #N/A.

I am really stuck, do not know what to do, I need to use 0 in next cell to clear the value as there is another sheet reading and calculating the last value, so when for an example: this month I have to make these payments, but, next month some of them I shall not pay, so, I need to zero the value for next month.

Thank you for your help


By: Demetris

Leave a Reply

Your email address will not be published. Required fields are marked *