I want to do a what if analysis for the caculation below. Is there a way to
use a cell reference to another worksheets in the same workbook for the
variables in the formula below ( ie. 0,500000,1000000, etc and
..0.01;-0.001;-0.0002 etc.)


=SUMPRODUCT(--(C5{0;500000;1000000;2500000;10000000}),C5-{0;500000;1000000;2500000;10000000},{0.01;-0.001;-0.0002;-0.005;-0.001})/365

Thus the formula would read something like this:

=SUMPRODUCT(--(C5{0;worksheet1 $c$1;worksheet1 $c$2;worksheet1
$c$3;worksheet1 $c$4}),C5-{worksheet1 $c$1;worksheet1 $c$2;worksheet1
$c$3;worksheet1 $c$4},{worksheet1 $d$1;worksheet1 $d$2;worksheet1
$d$3;worksheet1 $d$4})/365
with this formula is in worksheet2.

Any help would be appreciated.

Thanks