IF CELL VALUE FALLS WITHIN A RANGE OF VALUES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I create an IF function that allows me to work on a cell if the value
input falls within a range of values.

For example, =IF(A1=B1:B10,"true","false")
 
Sorry, it doesn't seem to work:

=IF(A1=AND(A1>=MIN(B1:B10),A1<=MAX(B1:B10)), "true", "false")

Am I doing it wrongly?
 
AND(A1>=MIN(B1:B10),A1<=MAX(B1:B10)) is the condition that is either TRUE or
FALSE. Use syntax rules as for any other condition. Here:

=IF(AND(A1>=MIN(B1:B10),A1<=MAX(B1:B10)),"true","false")
 
=IF(=AND(A1>=MIN(B1:B10),A1<=MAX(B1:B10)),"true","false")

Do I key it in as above? Doesn't seem to work. What else can I do? I would
expect this to be a simple task, that if a value falls within a value, do
this, if not, do this.

How about simplifying it to, if A1 falls within 4-12, true, false?
 
Could you just paste what I've posted, or what?
What is that eccentric equal sign?
=IF(AND(A1>=MIN(B1:B10),A1<=MAX(B1:B10)),"true","false")
 
Sorry, didn't see that = sign, must have been too stressed.

IT WORKED!! YOU'RE A GENIUS!

Thanks,
 
How about simplifying it to, if A1 falls within 4-12, true, false?

I'm assuming that "falls within 4-12" includes 4 and 12:

=AND(A1>=4,A1<=12)
 
Back
Top