PDA

View Full Version : [SOLVED] If Statement



spaz9876
07-29-2005, 01:32 PM
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
07-29-2005, 01:42 PM
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
07-29-2005, 01:46 PM
=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
07-29-2005, 02:13 PM
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
07-29-2005, 02:20 PM
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
07-29-2005, 02:32 PM
I changed it to B8<>"Open Market") instead of = and it worked.
Thank you

Zack Barresse
07-29-2005, 02:55 PM
Oh yes! Doh! :doh: Wrong operator.. :omg2:

MWE
08-01-2005, 05:56 AM
I changed it to B8<>"Open Market") instead of = and it worked.
Thank you

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