Prev: Used to return a worke sheet to origanan values
Next: Predefined text list
From: Norm on 15 Apr 2010 00:20
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 15 Apr 2010 00:27
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 15 Apr 2010 00:32
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!!!
 | 
Pages: 1
Prev: Used to return a worke sheet to origanan values
Next: Predefined text list