| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if else statement
I am creating an if else statement, but only seven nested if statements can be used in one cell, and i need to use 12 nested if statements how to i combine my if statments together in the two cells. I am using Excel XP Professional -- trixma ------------------------------------------------------------------------ trixma's Profile: http://www.excelforum.com/member.php...o&userid=25702 View this thread: http://www.excelforum.com/showthread...hreadid=395710 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if else statement
someone posted on this prior - solution is to do 6 of the ifs in one cell and the other 6 in another cell -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=395710 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if else statement
You can name the formulas the same way you name a range. In the Refers To:
box put a formula with 6 of your IF's. Give it a name like Formula1. Then do it again for the next 5 IF's and give it a name like Formula2. Then in your worksheet cell use them in a formula with your final IF something like this: IF(Formula1, Formula2, "Whatever") or IF(AND(Formula1, Formula2), "True", "False"), however you need to combine them. As you can see by giving a formula with 7 IF's a name, and then refering to that name in a formula, Excel now sees it as only 1 element, not 7. Getting around the 7 IF limit is much easier than keeping track of the logic needed to create a monster IF statement like this. Mike F "trixma" wrote in message ... I am creating an if else statement, but only seven nested if statements can be used in one cell, and i need to use 12 nested if statements how to i combine my if statments together in the two cells. I am using Excel XP Professional -- trixma ------------------------------------------------------------------------ trixma's Profile: http://www.excelforum.com/member.php...o&userid=25702 View this thread: http://www.excelforum.com/showthread...hreadid=395710 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if else statement
You should be looking at an alternative to nested IFs, such as VLOOKUP. Give
more details on the conditions and we can point you there. -- HTH RP (remove nothere from the email address if mailing direct) "trixma" wrote in message ... I am creating an if else statement, but only seven nested if statements can be used in one cell, and i need to use 12 nested if statements how to i combine my if statments together in the two cells. I am using Excel XP Professional -- trixma ------------------------------------------------------------------------ trixma's Profile: http://www.excelforum.com/member.php...o&userid=25702 View this thread: http://www.excelforum.com/showthread...hreadid=395710 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Hybrid Mode
