| 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 |
| 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 | |||
Threaded Mode
