| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List of functions contained in the add-ins, esp. Analysis Toolpak | Excel Worksheet Functions | |||
| The 7 nested If() function Limitation. Is there anouther way? | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Function limitation | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
