> The *only* way to repeat a calculation on more than one
> input is to literally copy and paste it.

Or use data tables. Very useful if you've spent ages making a whole 
sheet (or more) to model something (your "function") and then want to 
repeat that calculation over a range of values. You are limited to two 
"parameters" though.

> The mechanism they chose is to let you define a special "function
> worksheet". Certain cells are the function's input, and a certain cell
> is the function's output. Every time you call that function, notionally
> a new copy of this function worksheet is dynamically created with the
> appropriate cells filled in, and whatever ends up in the output cell is
> copied back to the formula that mentions the function.

I wouldn't be surprised if that is exactly how data tables work 
internally already.

Post a reply to this message