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.
|