Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I think I must not understand the "or" (and <) qualities of code, in an
If-Then statement. Here's my code: If MyType < "DIV" Or MyType < "UNM" Or MyType < "MOD" Then blah, blah, blah End If When MyType = "DIV", the code progresses to the [blah, blah, blah]. My little brain is trying to think that if MyType = "DIV", the code should bypass the [blah, blah, blah]. Please enlighten me. TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |