"False" returned in complex statement

[BillTony]

Hi there,

I am seeking to eliminate the "False" value from being returned within a fairly complex formula that is located in column AC.

I believe that this "False" is due to the 2nd condition in the formula.

All the text strings are hard-coded in the existing inventory system, and cannot be altered.

So: If the condition is met in column Z - AND the condition is met in column AA - the condition is must be met in column AB in order to take no action (blank...).

However, if the condition is not met in column AB, an order must be placed.

All of the testing I've done thus far indicates that this formula does indeed work as written.

However, I'm getting a "False" throughout the range in AC, and really need to just return a blank for the sake of legibility...

Thanks in advance!

=IF(NOT(ISNUMBER(SEARCH("Part in stock",Z3))),"", IF(SUMPRODUCT(--ISNUMBER(SEARCH({"5 units or greater","New Order Placed"},AA3)))>0,IF(ISNUMBER(SEARCH("No Action Needed",AB3)),"","PLACE ORDER NOW")))

 

[Fluff]

Try
=IF(NOT(ISNUMBER(SEARCH("Part in stock",Z3))),"", IF(SUMPRODUCT(--ISNUMBER(SEARCH({"5 units or greater","New Order Placed"},AA3)))>0,IF(ISNUMBER(SEARCH("No Action Needed",AB3)),"","PLACE ORDER NOW"),""))

 

[BillTony]

Thanks for such a quick reply.

You ALWAYS come up with a great solution!

 

[Fluff]

You're welcome & thanks for the feedback