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