If function limitation
 

Hi,

The IF function only allows a maximum of 7 logical tests to be inserted into
the function. I have a large amount of data that is filtered into different
categories and I want to separate these categories into 1 of 2 over arching
categories. By only allowing a max of 7 categories to be inserted, I can't
filter all the data I want to. Is there any way to get around this? Thanks,
--
miteeka

If function limitation
 

One way is to download the trial version of Office 2007, which greatly
expands the limit of nested functions.

There are other ways, such as using VLOOKUPs, etc.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"miteeka" wrote:

Hi,

The IF function only allows a maximum of 7 logical tests to be inserted into
the function. I have a large amount of data that is filtered into different
categories and I want to separate these categories into 1 of 2 over arching
categories. By only allowing a max of 7 categories to be inserted, I can't
filter all the data I want to. Is there any way to get around this? Thanks,
--
miteeka

If function limitation
 

Try to give a simple example of the data and what you mean by 'filter'
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"miteeka" wrote in message
...
Hi,

The IF function only allows a maximum of 7 logical tests to be inserted
into
the function. I have a large amount of data that is filtered into
different
categories and I want to separate these categories into 1 of 2 over
arching
categories. By only allowing a max of 7 categories to be inserted, I
can't
filter all the data I want to. Is there any way to get around this?
Thanks,
--
miteeka

If function limitation
 

On 1 Feb, 16:50, miteeka wrote:
Hi,

The IF function only allows a maximum of 7 logical tests to be inserted into
the function. I have a large amount of data that is filtered into different
categories and I want to separate these categories into 1 of 2 over arching
categories. By only allowing a max of 7 categories to be inserted, I can't
filter all the data I want to. Is there any way to get around this? Thanks,

If you use helper columns to code each individual IF statement into 0
or 1 for example =IF(A10),1,0), then you can use add and multiply to
build bigger IF's with multiple criteria and outputs.


Saul
www.notanant.com
communities of websites