Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |