If Function with OR

D

Darren

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
 
R

Ron Coderre

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
 
P

Paul Mathews

Hi Darren, what you want is something like this:

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

aidan.heritage

syntax you need is

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

hope this helps
 
R

Ron Coderre

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
 
Top