Results 1 to 5 of 5

Circular references and whether order of calculations is key for correct result

Threaded View

  1. #1
    Registered User
    Join Date
    09-09-2019
    Location
    London, England
    MS-Off Ver
    365
    Posts
    33

    Circular references and whether order of calculations is key for correct result

    Hi All
    Attached is a simple residual real estate appraisal I have built.
    It includes circular references, which I know are not ideal, but I have 'Iterative calculations' ticked under options.
    This appears to now be working, but I have had to really play around with the order in which calculations are made to make it work. Previously, and I cannot work out why my cell L75 was equaling my Gross Development Value in cell L25.
    Could it be that unless calculations are undertaken in the correct order that the boxes in yellow will be incorrect?
    I would really appreciate peoples comments on this and whether they think this appraisal now 'works' and is correct.
    Many thanks.
    Alex
    Attached Files Attached Files
    Last edited by Spitfire147; 11-30-2020 at 10:52 AM. Reason: Title incorrect.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trying to create a simple costing model on excel
    By faisal7 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-29-2017, 02:57 PM
  2. Simple Optimization Model - Help Needed
    By afgallday in forum Excel General
    Replies: 3
    Last Post: 04-09-2015, 02:32 AM
  3. Replies: 4
    Last Post: 08-20-2012, 10:47 AM
  4. Appraisal Due Dates
    By Josephw in forum Excel General
    Replies: 2
    Last Post: 09-27-2011, 07:03 AM
  5. Employee - Self Appraisal
    By Keerthivasan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2011, 07:15 AM
  6. Employee - Self Appraisal
    By Keerthivasan in forum Excel General
    Replies: 0
    Last Post: 07-21-2011, 06:55 AM
  7. Problem Displaying Specific Data From a Simple Model
    By ask4thesea in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2011, 10:48 PM

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