IF ISTEXT SEARCH OR AND functions

If cell A1 has a value " APPLE COMPUTER" and cell B1 has value" 16" IMAC" cell C1 should find APPLE IN A1 , 16" IN B1 AND RETURN VALUE "SMALL SIZE DESKTOP" if both conditions are matched orelse it should return" NONE" in cell C1

Hi,

it says the formula is not valid and then highlights "small

attachment

Hi
You can use 16" this way
=IF(SUMPRODUCT(--(A2:A7=" APPLE"),--(B2:B7=" 16"""))>0," SMALL SIZE"," NONE")

Formula:

=IF(SUMPRODUCT(--(A2:A7=" APPLE"),--(B2:B7=" 16"""))>0," SMALL SIZE"," NONE")

Regards

hi the result is none but it should display small size!