if or statement

I am trying to have a time cell filled based of off of what is in another cell. I came up with a formula that works until I put more than two conditions in it stops working. Here is my formula:

=IF(OR(G32=”AV”,G32=”BT”,G32=”DR”,G32=”OT”,G32=”NS”,G32=”RL”,G32=”TA”,G32=”ME”,G32=”VI”),NOW(),””)

My original formula was:

=IF(G32="RL",NOW(),"")

Cell G32 will have one of the listed results typed in and I want this cell to put the time of the entry in as it is being entered and the time will be a static after entry.

to Fix time stamp

Please Login or Register  to view this content.

Right-click on the sheet tab and "View Code".

Copy/paste the above into that sheet module.

When you enter data in any cell in column A, a static date/time stamp goes into
column B on same row.

and ...

=IF(OR(G32="AV",G32="BT",G32="DR",G32="OT",G32="NS",G32="RL",G32="TA",G32="ME",G32="VI"),NOW(),"")

you have italicised quotes ” ?????

Thank you for that information. I entered it and I works well for my column "A" to put date into my column "f". I also tried to put it in as:


but I get an error. I need the first for column "A" to date column "F" then for column "L" to date column "G". I thought I could just copy it again and change the variables but I get the "compile error: ambiguous name detected: Worksheet_change" message. This is what I put in:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'when entering data in a cell in Col L
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 1 Then
n = Target.Row
If Excel.Range("L" & n).Value <> "" Then
Excel.Range("G" & n).Value = Now
End If
End If
Thank you for any explanation of what I have done wrong.