need help on following nested if statement

  • Thread starter Thread starter billabong
  • Start date Start date
B

billabong

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
 
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 ")"
 
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
 
Back
Top