Help with an If-And Formula

[herpasymplex10]

here is the formula as is:

=IF(AND(C13="yes",B4<=5),"Over $250 or 5 Cartons","")


So if the value in B4 is less than or equal to 5 = True

I want to change it to
be if value is less than or equal to 5 or 7 or 8 = True


I can't seem to get it.
Help?

 

[NBVC]

Add an OR() function

=IF(AND(C13="yes",OR(B4<=5,B4<=7,B4<=8)),"Over $250 or 5 Cartons","")


although I am not sure that is really what you need....can't you just have AND(B4<>6,B4<=8)?

 

[herpasymplex10]

thanks a lot
that gave me what i needed