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

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

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

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