Forum Discussion
ISSUE WITH WHAT IF ANALYSIS
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.
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.
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.
- That's great! Thanks for helping me.