IF Calculation and Operations

R

Rich

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.
 
M

Murray

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 putin
North, if not put in South division.  
Click to expand...

Try =IF(OR(A1="Mets",A1="Pirates",A1="Cardinals"),"North","South")

Assuming your team name is in A1

HTH

Murray
 
Top