NOW() help

Norm · Apr 15, 2010

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

L. Howard Kittle · Apr 15, 2010

Try this,

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

HTH
Regards,
Howard

FSt1 · Apr 15, 2010

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

regards
FSt1