formula troubles

[Guest]

I've to compute variance ( "var" function in excel) for a lot of time series.
time series are in a file (say A.xls), and I compute formula in another file (say B.xls)
How can I compute the formula without change the range of values every time, and, if possibly
change the range only once
ex.: 3 time series
1st time series: var('[A.xls]sheet1!'B3:B10) - cell A3 ; var('[A.xls]sheet1!'B3:B50) - cell B
2nd time series: var('[A.xls]sheet1!'c3:c10) - cell a4 ; var('[A.xls]sheet1!'c3:c50) - cell b
3rd time series: var('[A.xls]sheet1!'d3:d10) - cell a5 ; var('[A.xls]sheet1!'d3:d50) - cell b

has someone got an example of a simple macro to compute

thanx to al

 

[Tom Ogilvy]

Use Edit=>Replace

If you have 6 different formulas, then, unless they have a mathematical
relationship, you will need to make 6 changes.

Look at help on OFFSET, INDIRECT, and INDEX if they do have a relationship.

--
Regards,
Tom Ogilvy

I've to compute variance ( "var" function in excel) for a lot of time series.
time series are in a file (say A.xls), and I compute formula in another file (say B.xls).
How can I compute the formula without change the range of values every time, and, if possibly,
change the range only once?
ex.: 3 time series.
1st time series: var('[A.xls]sheet1!'B3:B10) - cell A3 ;

var('[A.xls]sheet1!'B3:B50) - cell B3

2nd time series: var('[A.xls]sheet1!'c3:c10) - cell a4 ;

var('[A.xls]sheet1!'c3:c50) - cell b4

3rd time series: var('[A.xls]sheet1!'d3:d10) - cell a5 ;

var('[A.xls]sheet1!'d3:d50) - cell b5