I just put it into 2003, in cell E4, and you are exactly right Paul.
The formula goes in OK, if D4 is empty, but immediately you put something
into D4, you get the circular reference pop-up.
So, there's no difference between 2003 and 2010 in this.
Sharon ... don't you get a pop-up saying there's a circular reference?
Regards, Dave S
----- Original Message -----
From: "Paul Schreiner" <schreiner_paul@att.net>
To: <ExcelVBA@yahoogroups.com>
Sent: Saturday, June 02, 2012 5:42 AM
Subject: Re: [ExcelVBA] Formula from 2003 to 2010
If you're putting this formula in E4, then it should be giving you a
"Circular
Reference" error.
Possibly, you had your 2003 set to (probably) a low number of iterations
before
producing an error.
This actually should loop continuously..
because once NOW() is placed in E4, it would recalculate,
then E4 is not blank, so it places the value of E4 in E4, then
recalculates...
So... either your 2003 settings were such that it would ALLOW this circular
reference,
or something else is different.
Normally, I'd say that this formula cannot go into E4.
Check into the circular calculation limits.
Paul
-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------
________________________________
From: Dr John C Bullas <john.bullas@gmail.com>
To: ExcelVBA@yahoogroups.com
Sent: Fri, June 1, 2012 3:04:43 PM
Subject: Re: [ExcelVBA] Formula from 2003 to 2010
do you know anyone else running Excel 2010? does it work for them? I
would not expect such a simple formula to be changed by an upgrade
JB
On 1 June 2012 17:47, sheizageek <sheizageek@yahoo.com> wrote:
> The below formula worked great in an Excel 2003 file, but after converting
> to
>2010, the formula returns 1/0/00 0:00 instead of the Now() date and time. I
>have formatted the cells for the proper format.
>
> Typically, if data was entered into D4, then the timestamp would populate
> into
>E4. If nothing was entered, the cell was blank.
>
> Can anyone tell me how to fix this? I realize it isn't VBA, but thought
>someone may be able to assist.
>
> =IF(D4<>"",IF(E4="",NOW(),E4),"")
>
> Thanks
> Sharron
>
>
>
> ------------------------------------
>
> ----------------------------------
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
> here:
>http://www.mousetrax.com/techtrax to enter the ezine, then search the
>ARCHIVES
>for EXCEL VBA.
>
> ----------------------------------
> Visit our ExcelVBA group home page for more info and support files:
> http://groups.yahoo.com/group/ExcelVBA
>
> ----------------------------------
> More free tutorials and resources available at:
> http://www.mousetrax.com
>
> ----------------------------------Yahoo! Groups Links
>
>
>
--
===========================
http://uk.linkedin.com/in/drjohnbullas
[Non-text portions of this message have been removed]
------------------------------------
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------Yahoo! Groups Links
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1424 / Virus Database: 2425/5037 - Release Date: 05/31/12
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar