Forum Discussion
ISSUE WITH WHAT IF ANALYSIS
I am trying to create a data table with two variables, but when I'm initiating the what-if analysis, the data are coming all wrong.
1) All your currency values are text values, not numbers. You should remove the Rs. from the cells, and set the number format to a currency format that uses Rs.
2) A data table will only work if you have formulas. Without formulas, Excel has no way of knowing what you want to calculate.
In E6, enter the formula =E4*E5. This causes Excel to calculate the total price based on the price per apple and the quantity.
In F8, enter the formula =E6. This makes the top right cell of the data table equal to the total price in E6.
See the attached version.
8 Replies
Your screenshot shows a one-dimensional data table. You should specify E5 (the amount) as Column Input cell:
I did, but it's still showing the same results.
Are you sure that E6 contains the formula =E4*E5 and that F8 contains the formula =E6 ?
