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
|