| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Test within a range?
I have a range of sequintial starting and ending numbers in two columns.
Then I have a huge list of numbers that I need to verify if they fall between one of these ranges. For example A1 contains 1000000000 and B1 contains 1010000000 and C1 is 1000340568. I need a forumla in D1 that would return "True" that the C1 number is between A1 and B1. I tried COUNTIF but that only works for a list of numbers, not the start and end that I have in the above scenario. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Test within a range?
Try one of these:
Inclusive: =AND(C1=A1,C1<=B1) Between: =AND(C1A1,C1<B1) copy down as needed. Biff "JC" wrote in message ... I have a range of sequintial starting and ending numbers in two columns. Then I have a huge list of numbers that I need to verify if they fall between one of these ranges. For example A1 contains 1000000000 and B1 contains 1010000000 and C1 is 1000340568. I need a forumla in D1 that would return "True" that the C1 number is between A1 and B1. I tried COUNTIF but that only works for a list of numbers, not the start and end that I have in the above scenario. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Test within a range?
Thanks "T. Valko" wrote: Try one of these: Inclusive: =AND(C1=A1,C1<=B1) Between: =AND(C1A1,C1<B1) copy down as needed. Biff "JC" wrote in message ... I have a range of sequintial starting and ending numbers in two columns. Then I have a huge list of numbers that I need to verify if they fall between one of these ranges. For example A1 contains 1000000000 and B1 contains 1010000000 and C1 is 1000340568. I need a forumla in D1 that would return "True" that the C1 number is between A1 and B1. I tried COUNTIF but that only works for a list of numbers, not the start and end that I have in the above scenario. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Test within a range?
You're welcome!
Biff "JC" wrote in message ... Thanks "T. Valko" wrote: Try one of these: Inclusive: =AND(C1=A1,C1<=B1) Between: =AND(C1A1,C1<B1) copy down as needed. Biff "JC" wrote in message ... I have a range of sequintial starting and ending numbers in two columns. Then I have a huge list of numbers that I need to verify if they fall between one of these ranges. For example A1 contains 1000000000 and B1 contains 1010000000 and C1 is 1000340568. I need a forumla in D1 that would return "True" that the C1 number is between A1 and B1. I tried COUNTIF but that only works for a list of numbers, not the start and end that I have in the above scenario. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Test if the range is empty | Excel Discussion (Misc queries) | |||
| Test if CELL is in RANGE | Excel Worksheet Functions | |||
| Test for data in a range of cells | Excel Worksheet Functions | |||
| How I set up as logical test if my range has to be >=2 but <5 | Excel Discussion (Misc queries) | |||
| logical test - within a range | Excel Worksheet Functions | |||
Hybrid Mode
