Data/What If/Data Table Problems

[MrPerez]

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 · Accepted solution]

@MrPerez 

Are the formula implemented in column D?

i tired it and it worked

please see the file

[#3]

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