ExcelBanter - NOW() help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - NOW() help (https://www.excelbanter.com/excel-discussion-misc-queries/261551-now-help.html)

Norm

NOW() help

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

L. Howard Kittle

NOW() help

Try this,

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

HTH
Regards,
Howard

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

FSt1

NOW() help

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

regards
FSt1

"Norm" wrote:

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

All times are GMT +1. The time now is 10:01 PM.