| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with IIF statement in macro
I am using the followign statement in my macro:
Sheets("Split").Range("K" & LoopID).Value = IIf(Val(Sheets("New York").Range("I" & StartPoint) & "") < 4, "DATABASE", "FURNITURE") So I am saying if value in Range I < 4 then its DATABASE else its FURNITURE I want to add one more parameter.. that is if I < 4 then its Database if its between 4 to 7 then its Furniture and if its more than 7 then its Leasehold. Could someone please advise me on what the statement should be modified to. Thanks S Commar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro with an IF/OR statement | Excel Programming | |||
| Macro statement when opening file, but no macro | Excel Programming | |||
| Help I need a macro or IF Statement | Excel Programming | |||
| if then or statement in a macro | Excel Programming | |||
| Macro If Statement | Excel Programming | |||
Threaded Mode
