Previous Topic Next Topic

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?
Related:

1 response

Answer 1 / 1
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Dell laptop FN key is not working
adibah -
Artur -

93 responses