You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@poi.apache.org by vidhya murthy <vi...@gmail.com> on 2011/12/02 20:25:02 UTC

area num Index function excel 2007

Hi

I get a run time exception stating "Incomplete code don't know how to
support area_num parameter yet."

The formula I am trying to evaluate is

IF(Formulas!B43=TRUE,"Tuesday",INDEX(N16:N23,MATCH(MIN(O16:O23),O16:O23,0),1))

I do not have an area_num parameter in my formula so why does it still
complain?

Thanks
Vidhya

Re: area num Index function excel 2007

Posted by vidhya murthy <vi...@gmail.com>.

Please ignore this mail. I do not see any area num problems for the formula
i sent before. I had made a coding error.
Thanks
Vidhya

On Fri, Dec 2, 2011 at 2:25 PM, vidhya murthy <vi...@gmail.com>wrote:

>
> Hi
>
> I get a run time exception stating "Incomplete code don't know how to
> support area_num parameter yet."
>
> The formula I am trying to evaluate is
>
>
> IF(Formulas!B43=TRUE,"Tuesday",INDEX(N16:N23,MATCH(MIN(O16:O23),O16:O23,0),1))
>
> I do not have an area_num parameter in my formula so why does it still
> complain?
>
> Thanks
> Vidhya
>
>
>

-- 
Think before you print.