Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Formula
Dear All,
I want my out put to be as follows can any one help me on this it should check the condition A,B,C & out put in D as follows A B C D Change Request Status Change Type BO Approval NR/Enh In Normal NA NR/Enh Out Normal YES NR/Enh In PI NA NR/Enh Out PI NA NR/Enh In EC YES NR/Enh Out EC YES Bug In Normal NA Bug Out Normal NA Takeover In Normal YES TIA |
#2
|
|||
|
|||
Guessing
=IF(A2="NR Enh",IF(B2="In","NA","Yes"),"NA") -- HTH RP (remove nothere from the email address if mailing direct) "kiran" wrote in message ... Dear All, I want my out put to be as follows can any one help me on this it should check the condition A,B,C & out put in D as follows A B C D Change Request Status Change Type BO Approval NR/Enh In Normal NA NR/Enh Out Normal YES NR/Enh In PI NA NR/Enh Out PI NA NR/Enh In EC YES NR/Enh Out EC YES Bug In Normal NA Bug Out Normal NA Takeover In Normal YES TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |