+ Reply to Thread
Results 1 to 4 of 4

2 Way Data Table issues when running monte carlo simulation

Hybrid View

  1. #1
    Registered User
    Join Date
    03-03-2009
    Location
    us
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: 2 Way Data Table issues when running monte carlo simulation

    Thanks Andy for your response.

    How was it that you were able to determine that the calculations in the note were not the same?

    I tried to follow suit with a similar example, but have run into a similar issue as the previous sent. As suck I would like understand how you are able to determine and then repair this issue.

    I have attached a sample file. One table use a directly entered equation and the other uses a reference. Yet the one with the equation works and the other does not. In this situation how would you fix the issue?

    Again thank you for all of your help.

    Sincerely,
    Alpesh
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: 2 Way Data Table issues when running monte carlo simulation

    I guess the reference to C8 is not causing the cells to recalculate.

    If you change L11 formula to be =C11 you will see the difference.
    Cheers
    Andy
    www.andypope.info

+ 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