+ Reply to Thread
Results 1 to 5 of 5

Excel Calculation Direction Question

  1. #1
    Registered User
    Join Date
    01-11-2006
    Posts
    19

    Excel Calculation Direction Question

    My understanding of Excel is that the calculations are performed in Column A first and then down through the rows in Column A. After all the calculations are finished in A, the calculation moves over to Column B and down the rows in B. Is this true?

    I know that Excel is a little more complicated than that especially when it creates a queue for calculations, etc. However, assuming there's no calculation list/queue, would the above be correct?

    Thanks,

    Paula
    Last edited by paulabrozek; 08-26-2009 at 12:09 PM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,038

    Re: Excel Calculation Direction Question

    http://www.decisionmodels.com/calcsecretsc.htm
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Excel Calculation Direction Question

    See this page for just about everything to do with the calcualtion process.
    I'm intrigued as to why you need to know though?
    Remember what the dormouse said
    Feed your head

  4. #4
    Registered User
    Join Date
    01-11-2006
    Posts
    19

    Re: Excel Calculation Direction Question

    Quote Originally Posted by Special-K View Post
    Thanks!

    P

  5. #5
    Registered User
    Join Date
    01-11-2006
    Posts
    19

    Re: Excel Calculation Direction Question

    Quote Originally Posted by romperstomper View Post
    See this page for just about everything to do with the calcualtion process.
    I'm intrigued as to why you need to know though?
    I build economic models in excel for a living. Part of that job is to teach others to build efficient spreadsheets. I'm trying to show people how excel actually performs its calculations, such that people can set up their spreadsheets in such a way that minimizes the file size, performs calculations efficently, reduces links, etc.

    All that being said, I wasn't exactly sure how to explain how excel performs its calculations. The top down methodology that I described in my original post was more aimed at the "dependancies" that you replied with.

    Thanks for that.

    Paula

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1