| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there an If Or Then statement?
I'm trying to make this work but I get a Type Mismatch error. Any
clues? If strFrequency = "ea pay" Or "each pay" Or "Bi Weekly" Or "Bi-Weekly" Or "BI WEEKLY" Or "BI-WEEKLY" Or "bi weekly" Or "bi-weekly" Or "EA PAY" Or "EACH PAY" Or "Ea Pay" Or "Each Pay" Then Range("D11") = lAmount * 2 Else Range("D11") = lAmount End If |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
| Using an IF statement, or VLOOKUP statement | Excel Programming | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Threaded Mode
