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