Not Equal to, if statement

[john_utah]

This is super easy for the experts but I can't figure this out with 2 arguments

If cell D9 does not equal "WI" or "IA" then return a 1 - otherwise display 0

 

[DanteAmor]

Hi @john_utah, welcome to the forum

Try his

=IF(AND(D9<>"WI",D9<>"IA"),1,0)

 

[JayStax]

This is super easy for the experts but I can't figure this out with 2 arguments

If cell D9 does not equal "WI" or "IA" then return a 1 - otherwise display 0

Try this:

dim sheet1 as worksheet
dim range1 as range 'declare the sheet and the range(the cell)

Set sheet1 = 'insert sheet
set range1 = sheet1. 'reference after period

if sheet1.range1 <> "WI" OR if sheet1.range1 <> "IA" then

'return a 1 wherever youre tying to it

else

'return a 0

end if

 

[DanteAmor]

It can also be

=IF(OR(D9="WI",D9="IA"),0,1)

 

[Scott Huish]

For returning 1 or 0, the IF isn't necessary:

=1-(OR(D9={"WI","IA"}))

 

[john_utah]

This one worked perfectly! Thank you for the welcome as well! I didn't think of trying the and statement with this.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.