If function limitation

M

miteeka

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,
 
D

Dave F

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
 
B

Bernard Liengme

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

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,
Click to expand...

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
 
Top