placing NOW function in IF function
 

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.:)

As an example

=IF(A1="Brandon",NOW(),"")



--
HTH

Bob Phillips

"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.:)

You cannot change another cell with a formula.
You will need to use a macro to do that.
the appropriate code will depend on when you wnat the time stamp to occur.

The Now() function is not a good time stamp unless you copy and paste
special values as you apply it.
=now() in a cell will show current time (IE tomorrow it will show tomorrow,
not today.)


"Brandon" wrote:

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.:)

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.:)

Using NOW() will cause your timestamp to update every time the sheet
calculates. If that's what you want:

=IF(A1<100,NOW(),"")

Otherwise, see

http://www.mcgimpsey.com/excel/timestamp.html

In article ,
"Brandon" wrote:

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.:)

Thank you for your reply,
This is what I need to do. If Cell A1=Yes then I need cell B1 to get a
time stamp. I hope this helps explain what i'm trying to do exactly.
Thanks
"bj" wrote:

You cannot change another cell with a formula.
You will need to use a macro to do that.
the appropriate code will depend on when you wnat the time stamp to occur.

The Now() function is not a good time stamp unless you copy and paste
special values as you apply it.
=now() in a cell will show current time (IE tomorrow it will show tomorrow,
not today.)


"Brandon" wrote:

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.:)

Thank You all for your replies
I guess i have to make a macro but i'm pretty unexperienced at that. Any
help would be great.
Thanks a ton!!
Brandon:)
"JE McGimpsey" wrote:

Using NOW() will cause your timestamp to update every time the sheet
calculates. If that's what you want:

=IF(A1<100,NOW(),"")

Otherwise, see

http://www.mcgimpsey.com/excel/timestamp.html

In article ,
"Brandon" wrote:

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.:)

Check the link to David McRitchie's "Getting Started with Macros"
article on the page I referenced.

In article ,
"Brandon" wrote:

I guess i have to make a macro but i'm pretty unexperienced at that. Any
help would be great.

Hey,
I toyed around with this formula and got it to work:
=IF(A74=Inventory!A51,NOW(),"")
Thanks to all for your help
Brandon

p.s I did it without using any of the macros, thanks to all who suggested
it. I'm going to learn more about them now:)

"JE McGimpsey" wrote:

Check the link to David McRitchie's "Getting Started with Macros"
article on the page I referenced.

In article ,
"Brandon" wrote:

I guess i have to make a macro but i'm pretty unexperienced at that. Any
help would be great.

Again a warning about the Now(). it will update whenever the file is saved
or opened.

"Brandon" wrote:

Hey,
I toyed around with this formula and got it to work:
=IF(A74=Inventory!A51,NOW(),"")
Thanks to all for your help
Brandon

p.s I did it without using any of the macros, thanks to all who suggested
it. I'm going to learn more about them now:)

"JE McGimpsey" wrote:

Check the link to David McRitchie's "Getting Started with Macros"
article on the page I referenced.

In article ,
"Brandon" wrote:

I guess i have to make a macro but i'm pretty unexperienced at that. Any
help would be great.