[Solved] Win/draw/loss formula

[barnbogen]

I need a simple formula that lets if cell A is 1 then the value of cell d is 3
if the value of cell B is 1 then the value of cell d is 2
if the value of cell c is 1 then the value of cell d is 1

it's a simple results of a tournament: 3 points for a win; 2 points for a draw; 1 point for a loss

I can get 2 arguments, but not 3

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply (Hagar, Moderator).

[FJCC]

This should work in cell D2. Notice that I added the condition that if none of A2:C2 is equal to 1, the result is zero.

Code: Select all

=IF(A2=1;3;IF(B2=1;2;IF(C2=1;1;0)))

[barnbogen]

Man I'm just trying to create a win loss record for a pool of 4 teams and it's killing me:

the formula worked great for 3 for win 2 for draw and 1 for loss

but for the life of me I can't the logic if:
a scores 17 b scores 3
c scores 28 d scores 28
P W D L PF PA PD POINTS
MP1A 1823 1 1 0 0 17 3 14 3
MP1B ATLANTIS 1 0 0 1 3 17 -14 0
MP1C SOUTH 1 0 1 1 28 28 0 2
MP1D CHARLOTTE 1 0 1 0 28 28 0 2

these are just examples but I cannot get a 1 win 0 draw 0 loss; or 0 win 1 draw 0 loss
to work out logically, it just gives me a loss and a tie or win and a tie

[barnbogen]

this is the actual sheet that I'm trying to get a win/draw/loss table out of, then point values for win/loss/draw

then this is just the 1st round of games, how do I add the other results in

[FJCC]

I restricted the calculation to Sheet3. I assume you will have a summary table of matches as you do in A5:H10. I put formulas in M5:P10 to calculate who won, tied or lost each match. I changed the formulas in C16:L19 to sum the wins, losses and ties and the PA, PF for each team. You can add further results to the summary table to see how the results change.

[barnbogen]

that's exactly what I needed, brilliant. I don't know how to thank you. I hope that I can extrapolate this to all the other pools
thanks again