NOW() help

[Norm]

I want cell F5 to insert NOW() when D5 has a value entered
Not sure what the formula looks like
Cheers!!!

 

[L. Howard Kittle]

Try this,

=IF(D5<>0,NOW(),"")

HTH
Regards,
Howard

 

[FSt1]

hi
=IF(D5="","",NOW())

regards
FSt1