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

This One Is Tricky Need Help !!!!!	1	Jan 10, 2010
IF OR help	5	Feb 17, 2010
Help !!!	2	Jan 10, 2010
formula help	3	May 1, 2011
Formula is to long	8	Feb 26, 2010
Help with another formula, please	3	Feb 17, 2010
Average cells based on column header	6	Apr 5, 2011
For Mike H	2	Feb 17, 2010

Ask a Question