Log In
Register
Home
New Member
August 9, 2018
Offline
Hello everyone
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
Thanks
October 5, 2010
Offline
Hi Znar,
Have you read these posts:
https://www.myonlinetraininghu.....-explained
https://www.myonlinetraininghu.....-explained
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
=IF(AND(A1>0,A1<=14),"Yes",IF(A1>14,"No"))
The piece that evaluates if the number is between 0 and 14 inclusive is AND(A1>0,A1<=14)
Regards
Phil
1 Guest(s)
