Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exceedeing the 7 conditions in a nesting fomula
How can I exceed the 7 conditions that is the maximum number of conditions
alowed? Can I string together more then one set of 7 conditions? -- Thanks! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exceedeing the 7 conditions in a nesting fomula
In most cases, over 7 nested if formulae can be replaced wih HLOOKUP or
VLOOKUP Please post your formula. HTH -- AP "Nick" a écrit dans le message de news: ... How can I exceed the 7 conditions that is the maximum number of conditions alowed? Can I string together more then one set of 7 conditions? -- Thanks! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
having problems with a multiple conditions nesting formula | Excel Worksheet Functions | |||
Nesting conditions together. | Excel Discussion (Misc queries) | |||
Help in a fomula | Excel Discussion (Misc queries) | |||
Nesting more than 7 conditions? | Excel Worksheet Functions | |||
Nesting If Statement with "AND", "OR" conditions | Excel Worksheet Functions |