Tom I Know You Can Do It...
 

I am trying to write a formula by which I could be able to handle 1
conditions in total. Please help me out as Ms Excel can not handle mor
than 7 nested ifs. I have tried almost every thing, but no use. Pleas
show me a way out. How I can work around this situation.
My query is as follows. What I am trying to achieve is this:

Condition 1:

If the value in cell A1=81, and If the value in cell B1=21 then in cel
C3 show "good" else show "NE" (Remember the cell C3 is formatted b
conditional formatting which will turn to green if the value is GOOD i
the value is "NE" then show in yellow color.) Else it will be jus
white for any value.) Any ways conditional formatting is not an issue


Condition 2:

If the value in cell A1=82, and If the value in cell B1=21 then in cel
C3 show "BAD" else show "NE".

Condition 3:

If the value in cell A1=82, and If the value in cell B1=22 then in cel
C3 show "good" else show "NE"

Condition 4:

If the value in cell A1=83, and If the value in cell B1=21 then in cel
C3 show "BAD" else show "NE"

Condition 5:

If the value in cell A1=83, and If the value in cell B1=22 then in cel
C3 show "BAD" else show "NE"

Condition 6:

If the value in cell A1=83, and If the value in cell B1=23 then in cel
C3 show "good" else show "NE"

Condition 7:

If the value in cell A1=84, and If the value in cell B1=21 then in cel
C3 show "BAD" else show "NE"

Condition 8:

If the value in cell A1=84, and If the value in cell B1=22 then in cel
C3 show "BAD" else show "NE"

Condition 9:

If the value in cell A1=84, and If the value in cell B1=23 then in cel
C3 show "BAD" else show "NE"

Condition 10:

If the value in cell A1=84, and If the value in cell B1=24 then in cel
C3 show "BAD" else show "NE

--
Message posted from http://www.ExcelForum.com

Tom I Know You Can Do It...
 

Hi
pleae don't multipost (this is the 3rd one)

--
Regards
Frank Kabel
Frankfurt, Germany

I am trying to write a formula by which I could be able to handle 10
conditions in total. Please help me out as Ms Excel can not handle
more than 7 nested ifs. I have tried almost every thing, but no use.
Please show me a way out. How I can work around this situation.
My query is as follows. What I am trying to achieve is this:

Condition 1:

If the value in cell A1=81, and If the value in cell B1=21 then in
cell C3 show "good" else show "NE" (Remember the cell C3 is formatted
by conditional formatting which will turn to green if the value is
GOOD if the value is "NE" then show in yellow color.) Else it will
be just white for any value.) Any ways conditional formatting is not
an issue.


Condition 2:

If the value in cell A1=82, and If the value in cell B1=21 then in
cell C3 show "BAD" else show "NE".

Condition 3:

If the value in cell A1=82, and If the value in cell B1=22 then in
cell C3 show "good" else show "NE"

Condition 4:

If the value in cell A1=83, and If the value in cell B1=21 then in
cell C3 show "BAD" else show "NE"

Condition 5:

If the value in cell A1=83, and If the value in cell B1=22 then in
cell C3 show "BAD" else show "NE"

Condition 6:

If the value in cell A1=83, and If the value in cell B1=23 then in
cell C3 show "good" else show "NE"

Condition 7:

If the value in cell A1=84, and If the value in cell B1=21 then in
cell C3 show "BAD" else show "NE"

Condition 8:

If the value in cell A1=84, and If the value in cell B1=22 then in
cell C3 show "BAD" else show "NE"

Condition 9:

If the value in cell A1=84, and If the value in cell B1=23 then in
cell C3 show "BAD" else show "NE"

Condition 10:

If the value in cell A1=84, and If the value in cell B1=24 then in
cell C3 show "BAD" else show "NE"


---
Message posted from http://www.ExcelForum.com/

Tom I Know You Can Do It...
 

An array formula can perform multiple calculations and then return either a single result or multiple results. Array formulas act on two or more sets of values known as array arguments. Each array argument must have the same number of rows and columns. You create array formulas the same way that you create basic, single-value formulas. Select the cell or cells that will contain the formula, create the formula, and then press CTRL+SHIFT+ENTER to enter the formula.

Tom I Know You Can Do It...
 

=IF(OR(AND(A1=81,B1=21),AND(A1=82,B1=22),AND(A1=83 ,B1=23)),"Good",IF(OR(AND(
A1=82,B1=21),AND(A1=83,OR(B1=21,B1=22)),AND(A1=84, OR(B1=21,B1=22,B1=23,B1=24
))),"Bad","NE"))

should do what you want.

--
Regards,
Tom Ogilvy


"darno " wrote in message
...
I am trying to write a formula by which I could be able to handle 10
conditions in total. Please help me out as Ms Excel can not handle more
than 7 nested ifs. I have tried almost every thing, but no use. Please
show me a way out. How I can work around this situation.
My query is as follows. What I am trying to achieve is this:

Condition 1:

If the value in cell A1=81, and If the value in cell B1=21 then in cell
C3 show "good" else show "NE" (Remember the cell C3 is formatted by
conditional formatting which will turn to green if the value is GOOD if
the value is "NE" then show in yellow color.) Else it will be just
white for any value.) Any ways conditional formatting is not an issue.


Condition 2:

If the value in cell A1=82, and If the value in cell B1=21 then in cell
C3 show "BAD" else show "NE".

Condition 3:

If the value in cell A1=82, and If the value in cell B1=22 then in cell
C3 show "good" else show "NE"

Condition 4:

If the value in cell A1=83, and If the value in cell B1=21 then in cell
C3 show "BAD" else show "NE"

Condition 5:

If the value in cell A1=83, and If the value in cell B1=22 then in cell
C3 show "BAD" else show "NE"

Condition 6:

If the value in cell A1=83, and If the value in cell B1=23 then in cell
C3 show "good" else show "NE"

Condition 7:

If the value in cell A1=84, and If the value in cell B1=21 then in cell
C3 show "BAD" else show "NE"

Condition 8:

If the value in cell A1=84, and If the value in cell B1=22 then in cell
C3 show "BAD" else show "NE"

Condition 9:

If the value in cell A1=84, and If the value in cell B1=23 then in cell
C3 show "BAD" else show "NE"

Condition 10:

If the value in cell A1=84, and If the value in cell B1=24 then in cell
C3 show "BAD" else show "NE"


---
Message posted from http://www.ExcelForum.com/

Tom I Know You Can Do It...
 

Dear TOM,

You proved me right by answering the most amazing answer from all. Yo
deserve all the credit. You are really genius, this was from heart.


Warm Regards,


Darn

--
Message posted from http://www.ExcelForum.com