| 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) | |||
Linear Mode
