| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Calculation and Operations
I want to use a formula that will state IF team is Mets, Pirates, Cardinals
then put North, if not South. I don't know how to write an OR statement. In other words, if the team name is Mets, Pirates or Cardinals I want to put in North, if not put in South division. -- Rich |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Calculation and Operations
On Feb 4, 8:04*am, Rich wrote:
I want to use a formula that will state IF team is Mets, Pirates, Cardinals then put North, if not South. *I don't know how to write an OR statement. *In other words, if the team name is Mets, Pirates or Cardinals I want to put in North, if not put in South division. * -- Rich Try =IF(OR(A1="Mets",A1="Pirates",A1="Cardinals"),"Nor th","South") Assuming your team name is in A1 HTH Murray |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Calculation and Operations
-- Rich "Murray" wrote: On Feb 4, 8:04 am, Rich wrote: I want to use a formula that will state IF team is Mets, Pirates, Cardinals then put North, if not South. I don't know how to write an OR statement. In other words, if the team name is Mets, Pirates or Cardinals I want to put in North, if not put in South division. -- Rich Try =IF(OR(A1="Mets",A1="Pirates",A1="Cardinals"),"Nor th","South") Assuming your team name is in A1 HTH Murray |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Calculation and Operations
Thanks, it worked.
-- Rich "Murray" wrote: On Feb 4, 8:04 am, Rich wrote: I want to use a formula that will state IF team is Mets, Pirates, Cardinals then put North, if not South. I don't know how to write an OR statement. In other words, if the team name is Mets, Pirates or Cardinals I want to put in North, if not put in South division. -- Rich Try =IF(OR(A1="Mets",A1="Pirates",A1="Cardinals"),"Nor th","South") Assuming your team name is in A1 HTH Murray |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Repeat Operations | Excel Discussion (Misc queries) | |||
| how to concatenate operations | Excel Worksheet Functions | |||
| OWC operations in Excel | Excel Discussion (Misc queries) | |||
| Intersect operations | Excel Worksheet Functions | |||
| operations on arrays | Excel Worksheet Functions | |||
Linear Mode
