Calculating Multiple Outputs of a Single Cell

[Guest]

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.

 

[Guest]

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