IF ( GREATER THAN 5 AND EQUAL OR LESSER THAN 18) I NEED TO KNOW HOW TO USE THE FORMULA THAT CREATE ,QTY THAT IS MORE THAN 5 AND EQUAL OR LESSER THAN 18 IN DIFERENT CATEGORY.

What do you want the output to be if the criteria is met or not met? im confused. Here is what you could use but I based this on some assumptions.

Enter the formula in any cell apart from A1.

Then enter a number in A1=IF(AND(A1>5,A1<=18),"Greater than 5 but less than or equal to 18","Doesnt fit my specifications")

message edited by AlwaysWillingToLearn

Please do not post in All Caps. All Caps is the internet equivalent of yelling, and no one likes to be yelled at. Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think Microsoft's new Surface Go will be a hit?

Discuss in The Lounge

Poll History