IF CELL VALUE FALLS WITHIN A RANGE OF VALUES
 

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

IF CELL VALUE FALLS WITHIN A RANGE OF VALUES
 

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


"Melvin Tang" wrote:

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

IF CELL VALUE FALLS WITHIN A RANGE OF VALUES
 

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

"Melvin Tang" wrote:

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

IF CELL VALUE FALLS WITHIN A RANGE OF VALUES
 

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?

"Tevuna" wrote:

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

"Melvin Tang" wrote:

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

IF CELL VALUE FALLS WITHIN A RANGE OF VALUES
 

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. He

=IF(AND(A1=MIN(B1:B10),A1<=MAX(B1:B10)),"true","f alse")

"Melvin Tang" wrote:

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?

"Tevuna" wrote:

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

"Melvin Tang" wrote:

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

IF CELL VALUE FALLS WITHIN A RANGE OF VALUES
 

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

"Tevuna" wrote:

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

"Melvin Tang" wrote:

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

IF CELL VALUE FALLS WITHIN A RANGE OF VALUES
 

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","f alse")


"Melvin Tang" wrote:

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

"Tevuna" wrote:

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

"Melvin Tang" wrote:

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

IF CELL VALUE FALLS WITHIN A RANGE OF VALUES
 

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

IT WORKED!! YOU'RE A GENIUS!

Thanks,

"Tevuna" wrote:

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","f alse")


"Melvin Tang" wrote:

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

"Tevuna" wrote:

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

"Melvin Tang" wrote:

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

IF CELL VALUE FALLS WITHIN A RANGE OF VALUES
 

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)


--
Biff
Microsoft Excel MVP


"Melvin Tang" wrote in message
...
=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?

"Tevuna" wrote:

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

"Melvin Tang" wrote:

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