If Logic

[nirvehex]

Hi,

I have an if statement that is not quite working for me. Here is the code:

=IF(ISNUMBER(AND(SEARCH("Comp",D27),Dashboard!$H$16="Yes")),IF(E27="WD","No",IF(AP27<=2,"Yes","No")),IF(ISNUMBER(AND(SEARCH("Open",D27),Dashboard!$H$15="Yes")),IF(E27="WD","No",IF(AP27<=2,"Yes","No")),"No"))

It should return a "Yes" because of the following:
D27 = Open
E27 = T
AP27 = 1.77
DashboardH16="Yes"
DashboardH15="Yes"

Could someone please help me understand why my if statement is not getting to the point where it returns a "Yes" and how to fix it so it does? It keeps returning a "No."

Thanks!

 

[JoeMo]

Re: Help with If Logic

This:

AND(SEARCH("Comp",D27),Dashboard!$H$16="Yes"))

returns either TRUE or FALSE - not a number. So, the ISNUMBER will always return FALSE which takes the formula to the first "No".

 

[nirvehex]

Re: Help with If Logic

Thanks! Super helpful.