| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if cell value is between two numbers
Hi all,
I have a list of code numbers, 8 digits each in column A, formated as Text. I need to do a look up to another sheet and if found bring in a department code, but i must first check if the value per cell in column A is between 1. 10000000 and 13609999, then between 2. 00100000 and 00139999 and then lastley between 3. 00001000 and 00001399 If not then my code Any help would be much appreciated. -- Les |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check if cell value is between two numbers
Les
The data is Text. There is no "between" for text as there would be for numbers. Gord Dibben MS Excel MVP On Tue, 10 Jun 2008 15:16:00 -0700, Les wrote: Hi all, I have a list of code numbers, 8 digits each in column A, formated as Text. I need to do a look up to another sheet and if found bring in a department code, but i must first check if the value per cell in column A is between 1. 10000000 and 13609999, then between 2. 00100000 and 00139999 and then lastley between 3. 00001000 and 00001399 If not then my code Any help would be much appreciated. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check if cell value is between two numbers
You could perhaps use something like this?
check1 = False Check2 = False check3 = False If Int(myNum) = 10000000 And Int(myNum) <= 13609999 Then check1 = True ElseIf Int(myNum) = 100000 And Int(myNum) <= 139999 Then Check2 = True ElseIf Int(myNum) = 1000 And Int(myNum) <= 1399 Then check3 = True End If If check1 = False And Check2 = False And check3 = False Then 'run your code End If "Les" wrote: Hi all, I have a list of code numbers, 8 digits each in column A, formated as Text. I need to do a look up to another sheet and if found bring in a department code, but i must first check if the value per cell in column A is between 1. 10000000 and 13609999, then between 2. 00100000 and 00139999 and then lastley between 3. 00001000 and 00001399 If not then my code Any help would be much appreciated. -- Les |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check if cell value is between two numbers
Well done Libby
Gord On Tue, 10 Jun 2008 15:58:00 -0700, Libby wrote: You could perhaps use something like this? check1 = False Check2 = False check3 = False If Int(myNum) = 10000000 And Int(myNum) <= 13609999 Then check1 = True ElseIf Int(myNum) = 100000 And Int(myNum) <= 139999 Then Check2 = True ElseIf Int(myNum) = 1000 And Int(myNum) <= 1399 Then check3 = True End If If check1 = False And Check2 = False And check3 = False Then 'run your code End If "Les" wrote: Hi all, I have a list of code numbers, 8 digits each in column A, formated as Text. I need to do a look up to another sheet and if found bring in a department code, but i must first check if the value per cell in column A is between 1. 10000000 and 13609999, then between 2. 00100000 and 00139999 and then lastley between 3. 00001000 and 00001399 If not then my code Any help would be much appreciated. -- Les |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check or uncheck a check box based on a cell value | Excel Discussion (Misc queries) | |||
| Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
| how to check duplication of id numbers | Excel Worksheet Functions | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| check for duplicate numbers | Excel Worksheet Functions | |||
Hybrid Mode
