| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need help on following nested if statement
Hello: I'm trying to do the following on VBA:
If a cell contains the word "day" then write today's date, if not leave blank. If [e11] = "day" then [g11] = now Else [g11] = "" however if I wanted to include more criteria, i.e., different additional days (I believe the term is 'nested if statements') how do I go about it. For example: If [e11] = "day" then [g11] = Now Else [g11] = "" If [e11] = "T + 1" then [g11] = Now + 1 Else [g11] = "" If [e11] = "T + 2" then [g11] = Now + 2 Else [g11] = "" If [e11] = "T + 3" then [g11] = Now + 3 Else [g11] = "" If [e11] = "T + 4" then [g11] = Now + 4 Else [g11] = "" Thank you in advance Manuel |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need help on following nested if statement
Manuel,
The rule of thumb is: If(This,That,Else) If(This,That,If(this,that,If(..........))) Just keep replace Else with If(This,That,Else) The tricky part is remembering all the "," and ")" -- sb <billabong wrote in message ... Hello: I'm trying to do the following on VBA: If a cell contains the word "day" then write today's date, if not leave blank. If [e11] = "day" then [g11] = now Else [g11] = "" however if I wanted to include more criteria, i.e., different additional days (I believe the term is 'nested if statements') how do I go about it. For example: If [e11] = "day" then [g11] = Now Else [g11] = "" If [e11] = "T + 1" then [g11] = Now + 1 Else [g11] = "" If [e11] = "T + 2" then [g11] = Now + 2 Else [g11] = "" If [e11] = "T + 3" then [g11] = Now + 3 Else [g11] = "" If [e11] = "T + 4" then [g11] = Now + 4 Else [g11] = "" Thank you in advance Manuel |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need help on following nested if statement
billabong,
One way- If [e11] = "day" Then [g11] = Now ElseIf [e11] = "T + 1" Then [g11] = Now + 1 ElseIf [e11] = "T + 2" Then [g11] = Now + 2 ElseIf [e11] = "T + 3" Then [g11] = Now + 3 ElseIf [e11] = "T + 4" Then [g11] = Now + 4 Else [g11] = "" End If regards, JohnI <billabong wrote in message ... Hello: I'm trying to do the following on VBA: If a cell contains the word "day" then write today's date, if not leave blank. If [e11] = "day" then [g11] = now Else [g11] = "" however if I wanted to include more criteria, i.e., different additional days (I believe the term is 'nested if statements') how do I go about it. For example: If [e11] = "day" then [g11] = Now Else [g11] = "" If [e11] = "T + 1" then [g11] = Now + 1 Else [g11] = "" If [e11] = "T + 2" then [g11] = Now + 2 Else [g11] = "" If [e11] = "T + 3" then [g11] = Now + 3 Else [g11] = "" If [e11] = "T + 4" then [g11] = Now + 4 Else [g11] = "" Thank you in advance Manuel |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need help on following nested if statement
see ans in LATER post. "We must learn to have patience"
<billabong wrote in message ... Hello: I'm trying to do the following on VBA: If a cell contains the word "day" then write today's date, if not leave blank. If [e11] = "day" then [g11] = now Else [g11] = "" however if I wanted to include more criteria, i.e., different additional days (I believe the term is 'nested if statements') how do I go about it. For example: If [e11] = "day" then [g11] = Now Else [g11] = "" If [e11] = "T + 1" then [g11] = Now + 1 Else [g11] = "" If [e11] = "T + 2" then [g11] = Now + 2 Else [g11] = "" If [e11] = "T + 3" then [g11] = Now + 3 Else [g11] = "" If [e11] = "T + 4" then [g11] = Now + 4 Else [g11] = "" Thank you in advance Manuel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with nested IF statement | Excel Worksheet Functions | |||
| Nested IF statement | Excel Discussion (Misc queries) | |||
| Nested IF statement not need help | Excel Discussion (Misc queries) | |||
| Nested If Statement | Excel Worksheet Functions | |||
| IF and OR nested statement help | Excel Discussion (Misc queries) | |||
Linear Mode
