Do you have what it takes...

Hi
see your response in Excel.misc (for on possible solution). Please
don't multipost as this create additional efforts for all who responds
two your question

--
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"


Accept my appologies for being rude in Subject line, I know all
people
who answer are capable of doing almost everything that is possible in
excel.

Cheers!,

darno


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

Hi Darno!

I have a vlookup table in H1:L5

21 22 23 24
81 good NE NE NE
82 bad good NE NE
83 bad bad good NE
84 bad bad bad bad


That gives me the following:

=VLOOKUP(A1,$H$2:$L$5,B1-19)

Are you sure that 84 - 24 isn't supposed to be good?
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"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"


Accept my appologies for being rude in Subject line, I know all
people
who answer are capable of doing almost everything that is possible
in
excel.

Cheers!,

darno


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