Do you have what it takes...

[darno]

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"


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

Cheers!,

darn

 

[Frank Kabel]

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

 

[Norman Harker]

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