Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have a worksheet calcuating some results driven by different parameters.
Is there a way I can tabulated (probably in a separate worksheet) the different results against different tuples of parameter automatically or easily? Eg. For the worksheet that calculates current balance (the result) of my investment porfolio given a set of exchange rates (the parameters), I want a summary table showing how my balance changes with different exchange rates. With that table I shall then plot a chart for further sensitivity analysis. BTW, I am using Excel 2003 professional. Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mouse Sensitivity | Excel Discussion (Misc queries) | |||
Sensitivity analysis | Excel Worksheet Functions |