View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Murph Murph is offline
external usenet poster
 
Posts: 37
Default Time Stamp formula

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