Hi,
Jim Martin wrote:
Hello All:
I am trying to migrate away from ms excel and I was happy that the calc
in oo2.0 will open my largest spreadsheet. Unfortunately it gives an
error message regarding a formula that works fine in excel and in
gnumeric. The formula is something like this:
=AVERAGE(INDIRECT("c"&A2):INDIRECT("c"&b2))
where cell a2 and b2 contain integer values that represent the top and
bottom of a range that I wish to average in column b. I rely on this
type of forulation heavily in most of my spreadsheets. Calc gives me
Err:508 which indicates a missing bracket. As you can see, there is no
bracket error.
=AVERAGE(INDIRECT("c"&A2&":c"&b2))
will do the trick.
Regards
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
