IF statement

[Deaddog]

Should be an easy one for you guys, I'm trying to produce a time/date stamp without using VB code, needs to be a simple formula.

I'm trying this "=IF(F6="","",(now))" but it returns "#NAME?"

Any suggestions?

Thank you

 

[Joe4]

Actually, you may want to take a look at the "Circular References Trick to Automatically Insert Date and Timestamp in Excel" section of that link I sent you.
I have never tried it before, but it sounds like it may work.