Home |
Search |
Today's Posts |
#1
|
|||
|
|||
scenario analysis-multiple variables
Excel 2000
I want to change input variables (prices), while maintaining the same output (total price). i.e. If I decrease price 1 by 5%, how much do I have to increase prices 2,3, and 4 to achieve the same total price? |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
As I see the table is not readable, I placed the file for you he
http://spazioinwind.libero.it/franzv...le/joshjap.xls -- Hoping to be helpful... Regards Franz ---------------------------------------------------------------------------------------- To reply translate from italian InVento (no capital letters) ---------------------------------------------------------------------------------------- |
#4
|
|||
|
|||
As I see the table is not readable, I placed the file for you he
http://spazioinwind.libero.it/franzv...le/joshjap.xls -- Hoping to be helpful... Regards Franz ---------------------------------------------------------------------------------------- To reply translate from italian InVento (no capital letters) ---------------------------------------------------------------------------------------- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you populate the X variables in Regression analysis for mo. | Excel Worksheet Functions | |||
Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
How can I solve for multiple unknown variables in Excel? | Excel Discussion (Misc queries) | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) | |||
What is Multiple R, it is the first solution obtained in Regressi. | Excel Worksheet Functions |