multiple if statement formula help

[plost33]

I have the following formula which works great. I need to add one arguement to it. I have indicated its location in red in the second example. It should read: "if K2 is not "Mobilization/Build Out" OR "Demobilization".

i cannot seem to get the OR part to work.

=IF(AND(H2="Wild Well Control",B2<>"Talisman - Project Delayed Start",K2<>"Mobilization/Build Outs"),S2,IF(AND(B2<>"Talisman - Project Delayed Start",K2<>"Mobilization/Build Outs"),S2-Q2,"Mobe/Delay"))

=IF(AND(H2="Wild Well Control",B2<>"Talisman - Project Delayed Start",or(K2<>"Mobilization/Build Outs",K2<>"Demobilization")),S2,IF(AND(B2<>"Talisman - Project Delayed Start",K2<>"Mobilization/Build Outs"),S2-Q2,"Mobe/Delay"))

 

[texasalynn]

so what isn't working? It works for me

 

[jvanbonn]

Will this work?

=IF(AND(H2="Wild Well Control",B2<>"Talisman - Project Delayed Start",or(NOT(K2<>"Mobilization/Build Outs"),NOT(K2<>"Demobilization"))),S2,IF(AND(B2<>"Talisman - Project Delayed Start",K2<>"Mobilization/Build Outs"),S2-Q2,"Mobe/Delay"))

 

[Jonmo1]

Or and AND logic can get very tricky/confusing...

This
OR(K2<>"Mobilization/Build Outs",K2<>"Demobilization")
Will ALWAYS be TRUE, never false..
With the exeption of an Error Value in K2, then the OR returns the same error.

Think about it, wrap your head around it.

No matter what you put in K2, the OR will be true.

If K2 DOES = "Mobilization/Build Outs", then certainly K2 does NOT = "Demobilization"
So the OR is TRUE (1 of the 2 arguments was true).

If K2 DOES = "Demobilization", then certainly K2 does NOT = "Mobilization/Build Outs"
So the OR is TRUE (1 of the 2 arguments was true).

If K2 = ANYTHING else, then K2 certainly does not equal either "Mobilization/Build Outs" or "Demobilization"
So the OR is TRUE (both arguments are true)


I think you mean AND
So just add it to the original AND

=IF(AND(H2="Wild Well Control",B2<>"Talisman - Project Delayed Start",K2<>"Mobilization/Build Outs",K2<>"Demobilization"),S2,IF(AND(B2<>"Talisman - Project Delayed Start",K2<>"Mobilization/Build Outs"),S2-Q2,"Mobe/Delay"))

Hope that helps.

 

[plost33]

that was it! the and worked great. thanks for the great explaination! i love this forum!

 

[Jonmo1]

Glad to help, thanks for the feedback.

 

[jvanbonn]

jonmo1, your avatar is quite appropriate for AND/OR logic; at least with respect to my head.

Good explanation, Thanks!

Glad to help, thanks for the feedback.