Solved MS EXCEL ...I'm trying to create a formula

May 27, 2016 at 02:07:27
Specs: Windows 7
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.


See More: MS EXCEL ...Im trying to create a formula

Report •


#1
May 27, 2016 at 03:19:57
✔ Best Answer
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


Report •

#2
May 27, 2016 at 05:26:05
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.


Report •

Related Solutions


Ask Question