On May 2, 8:58 pm, Murph wrote:
fairly certain that there's a parantheses missing somewhere in that....

"vezerid" wrote:
On May 2, 6:11 pm, Murph wrote:
I am trying to place a time stamp in cell L2 if there is text inside of cells
F2:J2. This seems like it should be an easy thing to do but I can't wrap my
brain around it this morning.

The formula I have so far is simply:
=IF(F20,NOW(), )

This gives me a time stamp for only cell F2, but I need the formula to watch
from F2-J2. Thanks in advance.

=IF(OR(F2:J2<"",NOW(),"")

HTH
Kostis Vezerides


Yep, you are right:
=IF(OR(F2:J2<""),NOW(),"")

Regards,
Kostis