From: Norm on
I want cell F5 to insert NOW() when D5 has a value entered
Not sure what the formula looks like
Cheers!!!
From: L. Howard Kittle on
Try this,

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

HTH
Regards,
Howard

"Norm" <Norm(a)discussions.microsoft.com> wrote in message
news:35796CE3-C85B-4903-AF02-00C5D62509A8(a)microsoft.com...
>I want cell F5 to insert NOW() when D5 has a value entered
> Not sure what the formula looks like
> Cheers!!!


From: FSt1 on
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!!!