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]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

• New Members 5

Visit Your Group

----------------------------------
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

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___