| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another basic question... CASE with a range
How would I do the following? I can not find anything about AND/OR in the
VBA help file... if a is equal to and greater than x and if a is less than z q=1 if a is equal to and greater than b and if a is less than c q =2 if a is equal to and greater than e and if a is less than f q=3 otherwise q = 0 etc... Thank you Phil |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Another basic question... CASE with a range
Have a look in vbe HELP index for Select
-- Don Guillett SalesAid Software "Phillips" wrote in message news:ZKNub.249379$Fm2.259879@attbi_s04... How would I do the following? I can not find anything about AND/OR in the VBA help file... if a is equal to and greater than x and if a is less than z q=1 if a is equal to and greater than b and if a is less than c q =2 if a is equal to and greater than e and if a is less than f q=3 otherwise q = 0 etc... Thank you Phil |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Another basic question... CASE with a range
Phillips,
what do you want q to be if a is equal to and greater than x and if a is less than z AND a is equal to and greater than b and if a is less than c AND a is equal to and greater than e and if a is less than f? Henry "Phillips" wrote in message news:ZKNub.249379$Fm2.259879@attbi_s04... How would I do the following? I can not find anything about AND/OR in the VBA help file... if a is equal to and greater than x and if a is less than z q=1 if a is equal to and greater than b and if a is less than c q =2 if a is equal to and greater than e and if a is less than f q=3 otherwise q = 0 etc... Thank you Phil |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Another basic question... CASE with a range
Select Case True
Case a = x and a < z q = 1 Case a = b and a < c q = 2 Case a = e and a < f q = 3 Case else q = 0 End Select -- Regards, Tom Ogilvy "Phillips" wrote in message news:ZKNub.249379$Fm2.259879@attbi_s04... How would I do the following? I can not find anything about AND/OR in the VBA help file... if a is equal to and greater than x and if a is less than z q=1 if a is equal to and greater than b and if a is less than c q =2 if a is equal to and greater than e and if a is less than f q=3 otherwise q = 0 etc... Thank you Phil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Very basic VBA question. | Excel Discussion (Misc queries) | |||
| basic question | New Users to Excel | |||
| Basic question...sorry | Excel Worksheet Functions | |||
| Basic question | Excel Discussion (Misc queries) | |||
| Too Basic A Question | Excel Programming | |||
Linear Mode
