Alex has attended:
Excel Intermediate course
Scenario Management
I am trying to set a value range to a changing variable. As an example I have a standard capital cost analysis whereby £3.5 generates up to 130 units and £5.5 equals 260 units etc etc. I am preparing a spreadsheet where I can input the number of units and the capital investment cell needs to be used bases on an interest per capital. I believe scenario management is the answer, as I have over 60 variable cells, can you please explain how I can complete this calculation
RE: Scenario Management
Hi Alex
Thank you for your question. I wonder if data tables might be more helpful, based on your description. You can get an overview here
https://www.stl-training.co.uk/article-1194-how-create-data-table-in-excel-2010.html
and also from Microsoft directly at
http://support.microsoft.com/en-us/kb/282856
I hope this is helpful - let us know if you have any further questions.
Kind regards,
Andrew