If Statement

[spaz9876]

I am trying to do an If statement that if I8 = 1 AND B8 does not say "Open Market" then = L8, else M8

I have one part
=IF(I8=1,L8,M8) which works but I dont know how to add the "does not equal" part.

Can anyone help me?

[malik641]

I am trying to do an If statement that if I8 = 1 AND B8 does not say "Open Market" then = L8, else M8

I have one part
=IF(I8=1,L8,M8) which works but I dont know how to add the "does not equal" part.

Can anyone help me?


=IF(AND(I8=1,B8<>"Open Market"),L8,M8)

Hope this helps!!

[Zack Barresse]

=IF((I8=1)*(B8="Open Market"),L8,M8)

Edit: Doh! That's what you get when you pause too long to do something else when you should be answering questions! :p

[spaz9876]

Ok that first one works if B8 DOES equal Open Market. How could I switch it to Does Not?

The second solution didn't work.

[Bob Phillips]

Ok that first one works if B8 DOES equal Open Market. How could I switch it to Does Not?

The second solution didn't work.

No, Malik614's works if B8 does not equal.

[spaz9876]

I changed it to B8<>"Open Market") instead of = and it worked.
Thank you

[Zack Barresse]

Oh yes! Doh! :doh: Wrong operator.. :omg2:

[MWE]

I changed it to B8<>"Open Market") instead of = and it worked.
Thank you

if this resolves your problem, please make the thread Solved.