Help a high school newbie

[dshiver]

I keep scores of my high schools games in excel. example I have the teams we play in column A, column B is our scores and column C is our opponent scores. What I would like to do is in column d have it automatically add a win if column B is greater than column C and in column E have it place a win in the opponents column if column C is greater than B. I think there is a way to say if column B is greater than column C then = 1 or if column B is less than column C then = 0.
How do I set this up?

 

[Iridium]

On 2002-10-24 07:15, dshiver wrote:
I keep scores of my high schools games in excel. example I have the teams we play in column A, column B is our scores and column C is our opponent scores. What I would like to do is in column d have it automatically add a win if column B is greater than column C and in column E have it place a win in the opponents column if column C is greater than B. I think there is a way to say if column B is greater than column C then = 1 or if column B is less than column C then = 0.
How do I set this up?

You can do it all in one column -

C1=IF(B1>C1,"We Won ","We lost ")

 

[rmcbreen]

If you are looking to keep your original format here is an idea:

D1=if(B1>C1,0+1,0+0)
D2=if(b2>c2,d1+1,d1+0)
d3=if(b2>c2,d2+1,d2+0)
continue pattern down

To place the W in column E
E1=if(B1>C1,W,L)
E2=if(B2>C2,W,L)
Continue pattern