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 <[email protected]> wrote: > 2011/8/3 Joseph Da Silva <[email protected]>: >> 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 [email protected] > For additional commands send email to [email protected] > with Subject: help -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
