Having issue with an IF formula

[iowagrad2003]

Hello,

I had a question on an if formula which I pasted below. I recently added the first IF (And) portion of the formula and when I did that, it gives me false. My intention is if the row meets the first test, to continue in the process of the if statement and produce a number. I've included my workbook with the formula before (see J3) and after (see J2) I added the first test. Any insight? Thanks!

=IF(AND($M$3&$M$6&$M$9&$M$12<>"",NOT(ISNUMBER(SEARCH(A3,$M$3&$M$6&$M$9&$M$12)))),N(J2),IF(AND($M$15&$M$18&$M$21&$M$24<>"",NOT(ISNUMBER(SEARCH(B3,$M$15&$M$18&$M$21&$M$24)))),N(J2),IF(AND($M$27&$M$30&$M$33&$M$36<>"",NOT(ISNUMBER(SEARCH(C3,$M$27&$M$30&$M$33&$M$36)))),N(J2),IF(AND($M$39&$M$42&$M$45&$M$48<>"",NOT(ISNUMBER(SEARCH(D3,$M$39&$M$42&$M$45&$M$48)))),N(J2),IF(AND($M$51&$M$54&$M$57&$M$60<>"",NOT(ISNUMBER(SEARCH(E3,$M$51&$M$54&$M$57&$M$60)))),N(J2),IF(AND($M$39&$M$42&$M$45&$M$48<>"",NOT(ISNUMBER(SEARCH(D3,$M$39&$M$42&$M$45&$M$48)))),N(J2),IF(AND($M$51&$M$54&$M$57&$M$60<>"",NOT(ISNUMBER(SEARCH(E3,$M$51&$M$54&$M$57&$M$60)))),N(J2),IF(AND($M$63&$M$66&$M$69&$M$72<>"",NOT(ISNUMBER(SEARCH(F3,$M$63&$M$66&$M$69&$M$72)))),N(J2),N(J2)+1))))))))

[FDibbins]

what exactly are you trying to do here?

[iowagrad2003]

Based on what I select as criteria in Column M, Column O will spit out anything from column G that meets all the criteria selected. However, I also want to a test on min budget and capacity (M75 and M78).If the amounts in either one of those cells are higher than the amounts in column F&H, it would eliminate that line. But I don't want the formula to produce a false, but treat it the same if it didn't meet the other criteria (i.e, I would select a neighborhood - River North, but that line is in another neighborhood).

The formula works great before I tried to add the additional piece. J3 has my original formula where J2 is with my addition.

Thanks!

[FDibbins]

If you use the formula auditing window (click the cell with the formula, then click the Fx to the left of the formula bar), you will see that you have no "else" option for your 1st IF.

if this part is NOT true...
IF(AND(F2>=$M$78,H2>=M75)
then what do you want to happen? (you need to add that at the end)

[iowagrad2003]

This was extremely helpful! Thanks!!!

Marking thread as solved. Have a great night.

[FDibbins]

Glad it worked for you