2010 IF function help [Solved/Closed]

Report
Posts
3
Registration date
Monday November 18, 2013
Status
Member
Last seen
November 19, 2013
-
 Blocked Profile -
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


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!
Posts
3
Registration date
Monday November 18, 2013
Status
Member
Last seen
November 19, 2013

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?
Blocked Profile
Just check for <>"" (not equal to "").