Forum Discussion
Solved
Trouble creating formula for yes/no of values in a range
Hello! I need help with computing a formula which would answer "yes/no" in a cell if a value(s) is between a value range. I have attached snapshot to help follow through. Additionally, I am unabl...
anniehoang you can use this formula
=IF(OR(AND($N1>400,$N1<500),AND($O1>400,$O1<500)),"Yes","No")and copy down or if you have array function you can use
=IF(OR(AND($N1:$N100>400,$N1:$N100<500),AND($O1:$O100>400,$O1:$O100<500)),"Yes","No")and just put it in the first cell and have the ranges reflect the range where the data is.
anniehoang you can use this formula
=IF(OR(AND($N1>400,$N1<500),AND($O1>400,$O1<500)),"Yes","No")and copy down or if you have array function you can use
=IF(OR(AND($N1:$N100>400,$N1:$N100<500),AND($O1:$O100>400,$O1:$O100<500)),"Yes","No")
and just put it in the first cell and have the ranges reflect the range where the data is.
mtarler thank you so much! this was really helpful!