Greater than Less than question!

[Robert]

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]

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]

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