Toms Gmail wrote:
... Eg from Excel ={10*LOG(SUM(10^((E15:L15+{1,2,3,4,5,6,7,8})/10))}.... I have found that Calc doesn't seem to recognize the { } and thus I have to use a much more complicated formula....
This works for me:
=10*LOG(SUM(10^((E15:L15+{1;2;3;4;5;6;7;8})/10)))
You need OOo 2.3 to support array constants like this.
<Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
