+ Reply to Thread
Results 1 to 2 of 2

Fake #DIV/0! errors in Data Table when using What-if Analysis ?

  1. #1
    Registered User
    Join Date
    04-14-2010
    Location
    Quebec, Quebec
    MS-Off Ver
    Excel 2007
    Posts
    6

    Red face Fake #DIV/0! errors in Data Table when using What-if Analysis ?

    Hello group,

    I have a large spreadsheet that I have setup as my base model. When I added a sensibility analysis ("What-if analysis") using "Data Table", I found an error I haven't been able to correct.

    If I enter variable data as values, no problem, I get the expected results.
    However, when I use formulas in the variables, I obtain some fake #DIV/0! errors for some of the variables. I have also found the result for some variables incorrect.
    The formulas I used in my variables have nothing to do with the base model.

    Have you any idea on how to solve this issue?
    Do you know of the limitations of Data Tables?

    My Table Data is I3:J14
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-14-2010
    Location
    Quebec, Quebec
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Fake #DIV/0! errors in Data Table when using What-if Analysis ?

    I am thinking that the MAX function can be causing the problem....do you guys know something about it?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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