Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
Formula needs tweaking - HELP!!
I think I can clarify exactly what I desire from my nested if effort:
Table A2:E8 ORIGIN DESTIN AIR NOW DESIRED DFW IAH 8W 1 1 PHX IAH HP 1 1 DTW IAH NW 0 1 MKE IAH NW 0 0 PIT IAH CO 1 1 IAH DTW CO 0 0 Desired Column Conditions 1. Keep (desired value=1) all NW flights with DTW, or MEM, or MSP in origin/destin. 2. Remove (desired value=0) all other NW flights. 3. Remove (desired value=0) all CO flights with DTW, or MEM, or MSP in origin/destin. 4. Keep (desired value=1) all other CO flights. 5. Keep (desired value=1) all other airline flights. Formula in cell D3 at this time: =IF((OR(A3="DTW",A3="MEM",A3="MSP",B3="DTW",B3="ME M",B3="MSP")*(OR(C3="C o",c3="nw")))=1,0,if(c3<"co",if(c3<"nw",1,"0")," 1")) This works for all conditions except the row with DTW, IAH, NW - which gives me gives a value of 0, when the conditions need it to be =1 For reference puposes, the correct values are presented in Column E, labeled the "desired" column. Please help me out on this one, thanks MAX. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with tweaking formula | Excel Worksheet Functions | |||
macro tweaking | Excel Discussion (Misc queries) | |||
Tweaking formula? | Excel Discussion (Misc queries) | |||
Golf Score Formula needs tweaking | Excel Discussion (Misc queries) | |||
"AutoPrint" type macro requires tweaking | Excel Discussion (Misc queries) |