August 9, 2018
Im glad to find this platform, i want to create a formula with IF where i can have an option if a number for example is between 0 to 20 give me Yes and greater than 14 gives me no, if not to say its in process. i know how to use the greater or smaller functions but i didn't know how to make it a range between two numbers.
I appreciate your time
October 5, 2010
Have you read these posts:
You're logic is inconsistent because 15 is both between 0 and 20, and greater than 14. In this case what do you want the answer to be, Yes or No?
If you want it so that numbers between 0 and 14 inclusive give a Yes, and numbers above 14 give a No then you can use this, assuming the number being evaluated is in A1
The piece that evaluates if the number is between 0 and 14 inclusive is AND(A1>0,A1<=14)