One way:

=IF(A1="Win","3",IF(A1="Tie","1","0"))

or if you want to do arithmetic with the results of that formula:

=IF(A1="Win",3,IF(A1="Tie",1,0))



MathDoctor wrote:

Any assistance is appreciated:

Column A will list results that a team has - only possible results are

"win", "tie", or "loss". You get three points for a win, one point for
a tie
and zero for a loss.

So if A1 is a win, B1 will display "3"

How would I write that equation. The below is not working ...
=IF(A1="Win","3"),IF(A1="Tie","1"),IF(A1="Loss","0 ")

--
MathDoctor
------------------------------------------------------------------------
MathDoctor's Profile: http://www.excelforum.com/member.php...o&userid=24216
View this thread: http://www.excelforum.com/showthread...hreadid=378284

--

Dave Peterson