If Function with OR
 

I am trying to use an IF function to asign a code per region. I have two
codes one code for two countries and an other code for all others. In my if
statement how will i get it to look for the two, i need something that works
like an OR. So IF the cell has Place1 or Place2 give it a specific code ELSE
give it another code.

Please Help

If Function with OR
 

Try something like this:

For
A1: (a country)

This formula assigns Place2 and Place3 to Region_1, all others are
Other_Region
B1: =IF(SUM(COUNTIF(A1,{"Place2","Place3"})),"Region_1 ","Other_Region")

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Darren" wrote:

I am trying to use an IF function to asign a code per region. I have two
codes one code for two countries and an other code for all others. In my if
statement how will i get it to look for the two, i need something that works
like an OR. So IF the cell has Place1 or Place2 give it a specific code ELSE
give it another code.

Please Help

If Function with OR
 

Hi Darren, what you want is something like this:

=IF(OR(A1,A2),first thing,secondthing)

"Darren" wrote:

I am trying to use an IF function to asign a code per region. I have two
codes one code for two countries and an other code for all others. In my if
statement how will i get it to look for the two, i need something that works
like an OR. So IF the cell has Place1 or Place2 give it a specific code ELSE
give it another code.

Please Help

If Function with OR
 

syntax you need is

=if(or(condition1,condition2),DoTrue,DoFalse)

hope this helps

Darren wrote:
I am trying to use an IF function to asign a code per region. I have two
codes one code for two countries and an other code for all others. In my if
statement how will i get it to look for the two, i need something that works
like an OR. So IF the cell has Place1 or Place2 give it a specific code ELSE
give it another code.

Please Help

If Function with OR
 

A bit shorter (and easier to follow)

A1: (a country)

B1: =IF(OR(A1="Place2",A1="Place3"),"Region_1","Other_ Region")

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

Try something like this:

For
A1: (a country)

This formula assigns Place2 and Place3 to Region_1, all others are
Other_Region
B1: =IF(SUM(COUNTIF(A1,{"Place2","Place3"})),"Region_1 ","Other_Region")

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Darren" wrote:

I am trying to use an IF function to asign a code per region. I have two
codes one code for two countries and an other code for all others. In my if
statement how will i get it to look for the two, i need something that works
like an OR. So IF the cell has Place1 or Place2 give it a specific code ELSE
give it another code.

Please Help