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.