IF CELL VALUE FALLS WITHIN A RANGE OF VALUES

[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")

 

[Guest]

=SUM(N(A1=B1:B10))
Ctrl + Shift + Enter

 

[Guest]

Non array:
=AND(A1>=MIN(B1:B10),A1<=MAX(B1:B10))

 

[Guest]

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?

 

[Guest]

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")

 

[Guest]

=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?

 

[Guest]

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")

 

[Guest]

Sorry, didn't see that = sign, must have been too stressed.

IT WORKED!! YOU'RE A GENIUS!

Thanks,

 

[T. Valko]

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)