IF Calculation and Operations

  • Thread starter Thread starter Rich
  • Start date Start date
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refining a list of states into simple territories 5
Preferred way to do sort order - column in table, or specified in query? 3
Calculate Percentage of Total for Category 6
Get sheet names 9
Finding the Largest Number, based on two criteria 1
Copying data from one workbook to another dependent on user select 1
Weighted Average in Pivot Table 5
Pivot Table Calculated Item 2

Back
Top