If function limitation

[Guest]

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,

 

[Guest]

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

 

[Bernard Liengme]

Try to give a simple example of the data and what you mean by 'filter'
best wishes

 

[Saul]

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(A1>0),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