+ Reply to Thread
Results 1 to 5 of 5

Data tables not returning correct output

Hybrid View

  1. #1
    Registered User
    Join Date
    10-18-2016
    Location
    Northern Virginia, US
    MS-Off Ver
    Professional Plus 2013
    Posts
    3

    Re: Data tables not returning correct output

    Thanks for the advice. File attached. Because this is a fairly complex model, I've stripped the naming after it but have otherwise attached the entire thing. Sensitivity tables are located on the Input tab at the very bottom. Calculated Equity Partner IRR (output) can be found in cell B108 on the Cash Flow tab but I've linked it to the Input tab as well. Other than that, all variable inputs can be found on the Input tab and have been highlighted in yellow for ease. As one can see, the "base case" IRR is only calculating correctly for the first table. All others are off.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help to get correct output of superscript
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2014, 07:56 AM
  2. No correct output
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-27-2014, 11:40 PM
  3. [SOLVED] Not getting correct output problem
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-19-2014, 08:44 AM
  4. [SOLVED] IF Comparison Function Not Returning Correct Data
    By emlit in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-24-2014, 01:44 PM
  5. [SOLVED] Returning data for Duplicates in correct order
    By ClickingNoise in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-12-2013, 07:08 AM
  6. Formula sometimes returning correct answer and sometimes returning 0
    By redimp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-09-2010, 06:28 AM
  7. [SOLVED] How do I compare output data from 2 pivot tables in a graph forma.
    By Doobi in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-06-2005, 08:08 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