Could it be that you have 6 closing parenthesis and only 5 opening parenthesis.
Steve
Sent from my iPad
On Aug 7, 2011, at 1:09 PM, Johnny Rosenberg <gurus.knu...@gmail.com> wrote:
> 2011/8/3 Joseph Da Silva <joseph_da_si...@hotmail.com>:
>> Hi
>>
>> Here is the code I am having an issue with in open org works in excel
>>
>>
>> =INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$30000,MATCH(MAX(Q28933:Q30000),Q28933:Q30000,0)))))
>>
>
> Have you tried to select that cell and then hit Ctrl+F2? Then you can
> easier debug the formula, by placing the cursor in different places of
> the formula to see the results of different parts of the formula.
> I don't know for sure, but aren't you supposed to use a ”;”
> (semicolon) as a parameter separator rather than a ”,” (comma)? Or
> maybe both work these days.
>
>>
>>
>> There seems there is an issue with the CELL command and using 3.30 version
>> on windows 7
>>
>>
>>
>> Any advise would be appreciated.
>>
>>
>>
>> Thanks for your time and consideration
>
> I'm not sure that I helped at all, though…
>
>
> Regards
>
> Johnny Rosenberg
> ジョニー・ローゼンバーグ
> --
> -----------------------------------------------------------------
> To unsubscribe send email to discuss-unsubscr...@openoffice.org
> For additional commands send email to sy...@openoffice.org
> with Subject: help
--
-----------------------------------------------------------------
To unsubscribe send email to discuss-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help
