Expert: Richard Rost - 7/8/2009

Question
I am trying to write an if then statement.  I would appreciate any of your help, thanks in advance.  Let me first try to explain to you what I am doing.  

There are 16 teams, and I am trying to have excel automatically calculate the points based off of where they finish.  Take team one for instance, if "Team 1" is in cell A1 but not in B1 = 3 points, but if "Team 1" is in cell A1 and B1 = 6 points, and but if "Team 1" is in cell A1 and B1 and C1 = 9 points.  And so on...  I appreciate hearing your opinion on the best way to do this

Answer
Depending on how many conditions you're talking about (there is a limit) then this would just be a complex IF statement:

=IF(AND(A1="Team 1",B1<>"Team 1"),3,IF(AND(A1="Team 1",B1="Team 1",6,IF(AND(A1="Team 1",B1="Team 1",C1="Team 1",9,0)))

You can use the IF function to have Excel place a value in a cell based on one or more conditions or values in other cells.

See this FREE tutorial on my web site for more information on how to use the IF function:

http://www.599cd.com/tips/excel/misc/if-function-sales-tax.asp?key=AllExperts

Let me know if you have any other questions or comments.

Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT EXCEL VIDEO TUTORIAL. Go to http://www.599cd.com/Excel/AllExperts


Cordially,

Richard Rost
599CD Computer Training
http://www.599cd.com

P.S. Also, don't forget to visit my FREE Microsoft Excel Tips & Tricks Page at http://www.599cd.com/Tips/AllExperts

P.P.S. I volunteer my time at AllExperts to help people, and I get a LOT of questions, so I can't take an hour to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp/AllExperts and I'll take as much time as you need to answer your question.

Out of work? Know someone who is? Get a FREE copy of my Computer Job Skills CD at http://www.599cd.com/JobSkills?key=AllExperts