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
Hi Znar,
Have you read these posts:
https://www.myonlinetraininghub.com/excel-if-statement-explained
https://www.myonlinetraininghub.com/excel-if-and-or-functions-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
