B
Brad Hull
I have an array that uses a (variable) number as an input and
calculates a "cost" as the output. On the same worksheet I have a
list of numbers (that will change periodically). I want to be able to
input each of these numbers into the array input cell and display the
resulting "cost" next to each number. I visualize 2 columns - the
first is the list of input values and the second is a "function" that
does two things: (1) sets the array input cell to the corresponding
input value, and (2) returns the "cost" calculation to "this" cell.
This all needs to happen automatically when the input value changes.
Help?
Thanks, Brad.
calculates a "cost" as the output. On the same worksheet I have a
list of numbers (that will change periodically). I want to be able to
input each of these numbers into the array input cell and display the
resulting "cost" next to each number. I visualize 2 columns - the
first is the list of input values and the second is a "function" that
does two things: (1) sets the array input cell to the corresponding
input value, and (2) returns the "cost" calculation to "this" cell.
This all needs to happen automatically when the input value changes.
Help?
Thanks, Brad.