A conditional equation with three possible outcomes?

N

Not a Math Doctor

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")
 
D

Dave Peterson

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.
 

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

Conditional w/ three possibilities 4
Problem with formula for finding last greater than/less than or equal to value 2
Sorting Tied Teams in League Table by Matches Between Themselves 1
If AND for large range of data 1
Find team name with highest winning % over multiple years(worksheets) 0
Tennis Scorecard Help 1
Referencing the values of multiple cells in conditinal formatting. 0
IF, AND & OR 3

Top