# Conditional w/ three possibilities

1. ## Conditional w/ three possibilities

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")  Register To Reply

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

presumably in cell b1  Register To Reply

3. ## Re: Conditional w/ three possibilities

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

--

Dave Peterson  Register To Reply

4. ## RE: Conditional w/ three possibilities

Try:

=(A1="Win")*3+(A1="Tie")*1

Notice that no "IF"s are neded. Also notice that "Loss" is automatically
covered since it yields zero anyway
--
Gary's Student

"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
>
>  Register To Reply

5. ## Re: Conditional w/ three possibilities

You were almost there.........just move a couple of parenthisis and add for
condition that B1 should be blank if cell A1 is blank (or accidently
contains anything else)........

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

Incidently, the double quotes you have around the numbers actually turn
their result into TEXT format, if you want actual numbers use same formula
but just delete those double quotes, like...........

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

Vaya con Dios,
Chuck, CABGx3

"MathDoctor" <MathDoctor.1qgnya_1118491501@excelforum-nospam.com> wrote in
message news:MathDoctor.1qgnya_1118491501@excelforum-nospam.com...
>
> 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
>  Register To Reply