2010 IF function help

Solved/Closed
Kingantz
Posts
3
Registration date
Monday November 18, 2013
Status
Member
Last seen
November 19, 2013
- Nov 18, 2013 at 06:43 AM
 Blocked Profile - Nov 18, 2013 at 11:37 AM
I'm looking to combine a IF function for one cell with a date function in another.
The aim is to have something like this:
=IF(A1=2099,"James Jones") but then as 2099 is entered I want A3 to have the NOW() function as date and time stamp of entry.

Is this possible?

1 reply

Blocked Profile
Nov 18, 2013 at 08:32 AM
Kingantz,
Yea it is possible.

The structure is as follows:
=if(logic_test,true,false)
so your formula is something like:

=if(a1=2099,now())


You had it!
0
Kingantz
Posts
3
Registration date
Monday November 18, 2013
Status
Member
Last seen
November 19, 2013

Nov 18, 2013 at 10:29 AM
Thank you Mark.
Not long after I posted this did I figure that out. It was a test run for bigger one actually which now can't get right. I have 28 numbers and names running on an IF function in A1 which then means I have to do it to the NOW() cell for A1 as well but can't get it to work.
Or is there an IF function that will allow anything entered into A1 to spawn the NOW() function for me?
0
Blocked Profile
Nov 18, 2013 at 11:37 AM
Just check for <>"" (not equal to "").
0