Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |