Forum Discussion
Formula - Put a non-False value into a field
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 t...
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.