Greater than Less than question!
 

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.

Greater than Less than question!
 

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.

Greater than Less than question!
 

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.