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

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

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

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