| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Function
I am trying to add another criteria to a "IF function" that isn't working.
My current IF statement is: IF(Or(AI3="A",And(AI3<"A",AH3<1,AL3="ZMO")),0,1) this formula works fine but when I added AL3="USMC" to the end of the formula it no longer returns the expected result. What do I need to add to the formula so that it returns an answer if AL3="USMC" also. Any help is appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Function
It depends on where you want it. Is it part of the OR function? Part of the
AND function? Or, is it a separate condition? -- Biff Microsoft Excel MVP "Lizz45ie" wrote in message ... I am trying to add another criteria to a "IF function" that isn't working. My current IF statement is: IF(Or(AI3="A",And(AI3<"A",AH3<1,AL3="ZMO")),0,1) this formula works fine but when I added AL3="USMC" to the end of the formula it no longer returns the expected result. What do I need to add to the formula so that it returns an answer if AL3="USMC" also. Any help is appreciated. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Function
As AL3 can not equal both "ZMO" and "USMC" at the same time, you probably
need to insert another OR function. Also, it is redundant to check for AI3="A", and AI3< "A". =IF(OR(AI3="A",AND(AH3<1,OR(AL3="USMC",AL3="ZMO") )),0,1) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Lizz45ie" wrote: I am trying to add another criteria to a "IF function" that isn't working. My current IF statement is: IF(Or(AI3="A",And(AI3<"A",AH3<1,AL3="ZMO")),0,1) this formula works fine but when I added AL3="USMC" to the end of the formula it no longer returns the expected result. What do I need to add to the formula so that it returns an answer if AL3="USMC" also. Any help is appreciated. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Function
tRY...
IF(Or(AI3="A",And(AI3<"A",AH3<1,AL3="ZMO"),And(A I3<"A",AH3<1,AL3="USMC")),0,1) By just adding the AL3="USMC", you are saying 'if AL3 = ZMO and USMC. Obviously, it can't be both at the same time. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Lizz45ie" wrote: I am trying to add another criteria to a "IF function" that isn't working. My current IF statement is: IF(Or(AI3="A",And(AI3<"A",AH3<1,AL3="ZMO")),0,1) this formula works fine but when I added AL3="USMC" to the end of the formula it no longer returns the expected result. What do I need to add to the formula so that it returns an answer if AL3="USMC" also. Any help is appreciated. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Function
Your question is not stated clearly enough. What exactly do you mean by
"returns an answer if AL3="USMC" also"... what does "also" apply to... the OR or the AND part? Or is it an AND condition coupled with the OR? These are the three possibilities as I see it. If you want it OR'ed with the other OR conditions... =IF(OR(AI3="A",AND(AI3<"A",AH3<1,AL3="ZMO"),AL3= "USMC"),0,1) or if you want it AND'ed with the other AND conditions... =IF(OR(AI3="A",AND(AI3<"A",AH3<1,AL3="ZMO",AL3=" USMC")),0,1) or if you want it AND'ed with the OR condition... =IF(AND(AL3="USMC",OR(AI3="A",AND(AI3<"A",AH3<1, AL3="ZMO"))),0,1) One of these should be what you want (depending on how you meant "also" to be interpreted). -- Rick (MVP - Excel) "Lizz45ie" wrote in message ... I am trying to add another criteria to a "IF function" that isn't working. My current IF statement is: IF(Or(AI3="A",And(AI3<"A",AH3<1,AL3="ZMO")),0,1) this formula works fine but when I added AL3="USMC" to the end of the formula it no longer returns the expected result. What do I need to add to the formula so that it returns an answer if AL3="USMC" also. Any help is appreciated. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Function
Sorry for the confusion. AL3 can equal USMC or ZMO. I want to know how do I
include the AL3="USMC" in the formula if AL3="USMC"? I tried all three of the suggested formulas, I got #Value! error. "Rick Rothstein" wrote: Your question is not stated clearly enough. What exactly do you mean by "returns an answer if AL3="USMC" also"... what does "also" apply to... the OR or the AND part? Or is it an AND condition coupled with the OR? These are the three possibilities as I see it. If you want it OR'ed with the other OR conditions... =IF(OR(AI3="A",AND(AI3<"A",AH3<1,AL3="ZMO"),AL3= "USMC"),0,1) or if you want it AND'ed with the other AND conditions... =IF(OR(AI3="A",AND(AI3<"A",AH3<1,AL3="ZMO",AL3=" USMC")),0,1) or if you want it AND'ed with the OR condition... =IF(AND(AL3="USMC",OR(AI3="A",AND(AI3<"A",AH3<1, AL3="ZMO"))),0,1) One of these should be what you want (depending on how you meant "also" to be interpreted). -- Rick (MVP - Excel) "Lizz45ie" wrote in message ... I am trying to add another criteria to a "IF function" that isn't working. My current IF statement is: IF(Or(AI3="A",And(AI3<"A",AH3<1,AL3="ZMO")),0,1) this formula works fine but when I added AL3="USMC" to the end of the formula it no longer returns the expected result. What do I need to add to the formula so that it returns an answer if AL3="USMC" also. Any help is appreciated. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Function
Maybe this is what you want then...
=IF(OR(AI3="A",AND(AI3<"A",AH3<1,OR(AL3="ZMO",AL 3="USMC"))),0,1) although most would probably prefer to write it like this... =IF(OR(AI3="A",AND(AI3<"A",AH3<1,OR(AL3={"ZMO"," USMC"}))),0,1) -- Rick (MVP - Excel) "Lizz45ie" wrote in message ... Sorry for the confusion. AL3 can equal USMC or ZMO. I want to know how do I include the AL3="USMC" in the formula if AL3="USMC"? I tried all three of the suggested formulas, I got #Value! error. "Rick Rothstein" wrote: Your question is not stated clearly enough. What exactly do you mean by "returns an answer if AL3="USMC" also"... what does "also" apply to... the OR or the AND part? Or is it an AND condition coupled with the OR? These are the three possibilities as I see it. If you want it OR'ed with the other OR conditions... =IF(OR(AI3="A",AND(AI3<"A",AH3<1,AL3="ZMO"),AL3= "USMC"),0,1) or if you want it AND'ed with the other AND conditions... =IF(OR(AI3="A",AND(AI3<"A",AH3<1,AL3="ZMO",AL3=" USMC")),0,1) or if you want it AND'ed with the OR condition... =IF(AND(AL3="USMC",OR(AI3="A",AND(AI3<"A",AH3<1, AL3="ZMO"))),0,1) One of these should be what you want (depending on how you meant "also" to be interpreted). -- Rick (MVP - Excel) "Lizz45ie" wrote in message ... I am trying to add another criteria to a "IF function" that isn't working. My current IF statement is: IF(Or(AI3="A",And(AI3<"A",AH3<1,AL3="ZMO")),0,1) this formula works fine but when I added AL3="USMC" to the end of the formula it no longer returns the expected result. What do I need to add to the formula so that it returns an answer if AL3="USMC" also. Any help is appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
