Formulas requiring a time stamp

[Guest]

I need to create a formula that will add the current System time to a given
cell if a given cell is greater than 0

 

[TommySzalapski]

if(A1>0,now())

Szalapsk

 

[Chip Pearson]

Try something like

=IF(A1>0,NOW(),"")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




message
news:[email protected]...