Formula - Put a non-False value into a field

Occasional Visitor

I have a list (show below) to compare the "paid Over" field with the running total.  It returns a false unless the value is more.  I want to then get the "9 Months ( or whatever # of months returns true in the list) to show in the "break Even cell" above so i can use the break even point in a graphic.  What formula do I use to search through a list and give me the value when "not false"



1 Reply



I've attached a sample file that uses INDEX and MATCH to produce the result. I didn't recreate your entire page, which didn't seem necessary. You can change either of the numbers with a yellow background to test the function.

This is the formula that is in cell B4 of the attached spreadsheet; an image of it is here.