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

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

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

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