Forum Discussion

MrPerez's avatar
MrPerez
Copper Contributor
Aug 21, 2020
Solved

Data/What If/Data Table Problems

Good afternoon,

I am trying to recreate an example of a book using the What if/Data table Analysis and I'm unable to get the same result as the book.

 

I'm using Home&Students MO2016. I'm using Automatic except for data tables.
Here is what I'm getting:

 

#2

 

#3

 

It doesn't do the calculationg for those values. No idea if it is my Excel version or if I have an option disable or another thing.

 

Thanks in advance.

2 Replies

    • MrPerez's avatar
      MrPerez
      Copper Contributor
      Thanks a lot!

      It was like you said. I wasn’t using any formula on the table below, that is why i wasn’t getting any result.

      Thanks again,

      Regards

Resources