| Home |
| Search |
| Today's Posts |
|
#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 |
| 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
