IF Not function

[powersml07]

Hi again. Im having trouble with an IF NOT formula and was wondering if someone could help me

What Im trying to accomplish is IF AG is LESS THAN 50, AJ is LESS THAN 7 and D2 DOES NOT contain the word Speakers in it, then return "Free Shipping". This is what i have right now, but it doesnt seem to be working correctly.

IF(NOT(AND(AG2<50,AJ2<7,ISNUMBER(SEARCH("Speakers",D2)))),"Free Shipping", ","")

Thanks in advance

[CK76]

Try...
=IF(AND(AG2<50,AJ2<7,ISERROR(SEARCH("Speakers",D2))),"Free Shipping","")

[mahju]

Hi
The conditions AG2<50 and AG2<7 will return true only if AG2<7 because AG2 > 7 will return false for group and false for the whole condition.

If you want condition between 7 & 50 try >7 & <50 conditions
Thhanks

[Jonmo1]

@mahju

You might want to read those conditions in the formula a little closer.

[CK76]

The conditions AG2<50 and AG2<7 ...

It's AG2 and AJ2 from OP

[powersml07]

Thank you everyone. I got it to work!!!