I'm trying to automate a score sheet for volleyball. With the teams playing
a max of 3 games, I would like to place the scores into there own cells and
compute a winner by a greater than less than formula.

Say the scores are as follows:

Team 1 Team 2
25 18
17 25
14 16

W 1 2
L 2 1

I want that formula to calculate that Team 2 has 2 wins and 1 loss while
Team 1 has 1 win and 2 losses. Can this be done by using only cells (no
"condition" such as greater than 25 since the third game will only go to 15)?

Thanks.

Assuming Data are in B2:C4
W for Team 1
=IF((B2-C2)0,1,0)+IF((B3-C3)0,1,0)+IF((B4-C4)0,1,0)

L for Team 1
=IF((B3-C3)<0,1,0)+IF((B4-C4)<0,1,0)+IF((B5-C5)<0,1,0)

you can alter the formula for the rest .

Best regards,
Edward


"Robert" wrote:

I'm trying to automate a score sheet for volleyball. With the teams playing
a max of 3 games, I would like to place the scores into there own cells and
compute a winner by a greater than less than formula.

Say the scores are as follows:

Team 1 Team 2
25 18
17 25
14 16

W 1 2
L 2 1

I want that formula to calculate that Team 2 has 2 wins and 1 loss while
Team 1 has 1 win and 2 losses. Can this be done by using only cells (no
"condition" such as greater than 25 since the third game will only go to 15)?

Thanks.

Edward I can't thank you enough. It worked!

Here are the formulas used:

=IF((D10-F10)0,1,0)+IF((D11-F11)0,1,0)+IF((D12-F12)0,1,0)
=IF((D10-F10)<0,1,0)+IF((D11-F11)<0,1,0)+IF((D12-F12)<0,1,0)

=IF((F10-D10)0,1,0)+IF((F11-D11)0,1,0)+IF((F12-D12)0,1,0)
=IF((F10-D10)<0,1,0)+IF((F11-D11)<0,1,0)+IF((F12-D12)<0,1,0)

I then wanted to get matches won so I did the following:

=IF((D17-F17)0,1,0)
=IF((D18-F18)0,1,0)

Thanks once again.

Robert

"Edward" wrote:

Assuming Data are in B2:C4
W for Team 1
=IF((B2-C2)0,1,0)+IF((B3-C3)0,1,0)+IF((B4-C4)0,1,0)

L for Team 1
=IF((B3-C3)<0,1,0)+IF((B4-C4)<0,1,0)+IF((B5-C5)<0,1,0)

you can alter the formula for the rest .

Best regards,
Edward


"Robert" wrote:

I'm trying to automate a score sheet for volleyball. With the teams playing
a max of 3 games, I would like to place the scores into there own cells and
compute a winner by a greater than less than formula.

Say the scores are as follows:

Team 1 Team 2
25 18
17 25
14 16

W 1 2
L 2 1

I want that formula to calculate that Team 2 has 2 wins and 1 loss while
Team 1 has 1 win and 2 losses. Can this be done by using only cells (no
"condition" such as greater than 25 since the third game will only go to 15)?

Thanks.