+ Reply to Thread
Results 1 to 1 of 1

Data Table - Linked Independent Variable

Hybrid View

jingham25 Data Table - Linked... 01-24-2022, 04:39 PM
  1. #1
    Registered User
    Join Date
    01-24-2022
    Location
    Boston
    MS-Off Ver
    Office 365
    Posts
    1

    Unhappy Data Table - Linked Independent Variable

    I have a simple real estate investment model that solves for an IRR. I would like to sensitize the IRR (cell C16) for changes in year 1 rent (cell D3) by using a data table.

    Is there any way to link the independent variable (cell B24) to the original input (cell D3) so that I don't have to hard code the data table y axis? In other words I want my data table y axis to update automatically when I change cell D3. Linking cell B24 to cell D3 seems to prevent the data table from calculating. I am forced to calculate the data table with a hard coded value (cell F24). This is causing me issues in more complex models with multiple inputs, more complex calculations and multiple data tables.
    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. Replies: 1
    Last Post: 08-31-2020, 04:02 PM
  2. Replies: 4
    Last Post: 05-07-2014, 03:08 AM
  3. Charting with y axis as independent variable
    By markhood01 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-07-2010, 05:30 AM
  4. charting horizontal axis/independent variable
    By eldormido in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-29-2009, 02:32 PM
  5. [SOLVED] add a second independent variable, doing regression in excel?
    By cheeks in forum Excel General
    Replies: 1
    Last Post: 04-02-2006, 07:10 PM
  6. Two Independent Variable Correlation
    By MillerK in forum Excel General
    Replies: 1
    Last Post: 04-20-2005, 11:06 PM

Tags for this Thread

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