Jul 20 2021 11:09 AM
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.
Jul 20 2021 11:58 AM
Your screenshot shows a one-dimensional data table. You should specify E5 (the amount) as Column Input cell:
Jul 20 2021 09:43 PM
I did, but it's still showing the same results.
Jul 21 2021 12:29 AM
Are you sure that E6 contains the formula =E4*E5 and that F8 contains the formula =E6 ?
Jul 21 2021 12:47 AM
Select cell E6. What do you see in the formula bar?
Then select cell F8. What do you see in the formula bar?
If you wish, you can attach your sample workbook to a reply. That will enable us to investigate it directly.
Jul 21 2021 12:53 AM
When I am selecting the specified cells, it's showing the value and not any formulas.
I am attaching the file, please check.
Thank You.
Jul 21 2021 03:42 AM
Solution1) 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.
Jul 21 2021 03:42 AM
Solution1) 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.