IF formula for time

Giganews Newsgroups
Subject: IF formula for time
Posted by:  fastballfreddy (fastballfreddy.27dn3m_1146903901.218@excelforum-nospam.com)
Date: Sat, 6 May 2006

I have cells A1 & B1.  What I want is when I put "1" into A1, for B1 to
show the current time.  Can I use an IF formula?  =IF(A1 =
1,"????","")

Thanks,

--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=33986
View this thread:http://www.excelforum.com/showthread.php?threadid=539501

Replies