Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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")
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 136
Default 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")

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 136
Default 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")

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default 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")

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 136
Default 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")



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default 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")

  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 136
Default 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")

  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default 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")

  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default 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")



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If date in cell falls between date range... Keep It Simple Stupid Excel Worksheet Functions 4 August 28th 07 10:02 PM
selecting multiple cell in a roll that falls withing a range Olamide Charts and Charting in Excel 1 March 15th 07 02:43 PM
Checking if a certain day falls in a range Jaydubs Excel Discussion (Misc queries) 6 March 16th 06 02:51 PM
update cell only if now() falls in a given date range treyn1292 Excel Worksheet Functions 0 February 16th 06 09:54 PM
Data falls in a range +/-1 SMac Excel Worksheet Functions 3 November 28th 05 09:34 PM


All times are GMT +1. The time now is 07:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"