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.
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 ?
- How do you mean?
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.
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.