A conditional equation with three possible outcomes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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")
 
See one response in .misc.

It's not necessary to multipost to multiple groups. But if you think it's
necessary, then post to all groups in one message.
 
Back
Top