View Single Post
  #4   Report Post  
Don Guillett
 
Posts: n/a
Default

try
=if(a1=2,now(),"")
be advised it will change each time the formula in a1 is true. So, if you
want a time STAMP not to change you will need a macro that only fires when
you desire. Further info?

--
Don Guillett
SalesAid Software

"Brandon" wrote in message
...
Hey,
I'm trying to use the IF function to create a time stamp in another cell
if the Logical_Test is true. I'm kinda at a loss. If anyone could help me
that would be fantastic.
Thank you so much.:)