Apache OpenOffice Community Forum

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).

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.

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

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

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.

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