|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