Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating Multiple Outputs of a Single Cell
How does one calculate and present a column of output values for a single
cell as a function of a column of input variables to a different cell? That is, say, in a financial model, calculate and present a column of 50 NPVs as a function of a column of 50 different inputs for a single year's revenue? To extend that, NPVs as a function of 50 dirrerent revenue streams over time. Use arrays? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating Multiple Outputs of a Single Cell
I'm not a financial person, but the only way I could see would be to set up
macros to select each value in turn and use it in the calculations, repeating until the list was exhausted........ hth 'Vaya con Dios, Chuck, CABGx3 "lsmull" wrote: How does one calculate and present a column of output values for a single cell as a function of a column of input variables to a different cell? That is, say, in a financial model, calculate and present a column of 50 NPVs as a function of a column of 50 different inputs for a single year's revenue? To extend that, NPVs as a function of 50 dirrerent revenue streams over time. Use arrays? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
How to sum the values of a single cell from multiple worksheets | Excel Worksheet Functions | |||
Multiple coin flips in a single cell | Excel Worksheet Functions | |||
Can multiple cell results be displayed in a single cell? | Excel Discussion (Misc queries) | |||
Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) |