IF - OR statement with 2+ conditions

[BurkeDad]

I am trying to create an if-or statement with 2+ conditions. Here is what I have thus far. Where am I going wrong.

=if((B2="USGS",1),or(B2="CONT",2),or(B2="VOL",1),0)

 

[kidwispa]

I am trying to create an if-or statement with 2+ conditions. Here is what I have thus far. Where am I going wrong.

=if((B2="USGS",1),or(B2="CONT",2),or(B2="VOL",1),0)

What is the result you are looking to return?

Try laying your formula out like this:

=IF(OR(condition1,condition2,etc),value if true,value if false)

So for example if B2 is either USGS or CONT then show 1 otherwise show 2 then your formula would read:

=IF(OR(B2="USGS",B2="CONT"),1,2)

Hope this helps!

 

[tc88]

I am trying to create an if-or statement with 2+ conditions. Here is what I have thus far. Where am I going wrong.

=if((B2="USGS",1),or(B2="CONT",2),or(B2="VOL",1),0)

Try this:

=IF(OR(B2="USGS",B2="VOL"),1,IF(B2="CONT",2,0))

 

[BurkeDad]

Thanks for the help all. They all worked great - used the last one because I actually needed 3 conditions.

Thanks again for the help!