IS NUMBER SEARCH with TWO conditions

[Mr2017]

Hi

I've got a formula which searches for specific text in a cell, then returns a phrase if that text is in the cell.

In the example below, if the word "Now" appears in the text in cell A1, then the phrase "Fixed Price Discount" will appear in cell B1.

The formula I have used is =IF(ISNUMBER(SEARCH("Now",A2)),"Fixed Price Discount","")

However, I'd like to know if it's possible to use this formula to search for TWO conditions.

Eg if the word "for" and the currency sign "£" appears in a cell, then I'd want the formula to return the phrase "Fixed price multibuy." If the word "for" appears in a cell BUT the currency sign "£" DOES NOT appear in the cell, then I'd want the phrase "Cheapest free" to appear in the corresponding cell. Is that possible? I'd prefer to avoid using IF(AND as there are dozens of combinations like the "6 for x" and "6 for £x" described below eg "3 for 2" and "3 for £2" and I'll run out of space! Excel can only take 64 arguments in a nested IF!

Thanks in advance.

[TABLE="width: 285"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Mechanic[/TD]
[TD]Conversion [/TD]
[/TR]
[TR]
[TD]Now £2[/TD]
[TD]Fixed Price Discount[/TD]
[/TR]
[TR]
[TD]6 for 4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]6 for £4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3 for 2[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3 for £2[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[AlanY]

try

=IF(ISNUMBER(SEARCH("for",A2)),IF(ISNUMBER(SEARCH("£",A2)),"Fixed price multibuy.","Cheapest free"),IF(ISNUMBER(SEARCH("Now",A2)),"Fixed Price Discount",""))

 

[Mr2017]

Ok, great. Thanks Alan.

 

[AlanY]

you're welcome