# win loss formula?

Detroit is playing Green Bay right now. If Detroit wins or losses, when I type in the score on my excel spreadsheet, is there a formula that will add one to the win column, if they win, or one to the lose column if they lose?
Thanks

 BizBlogBuzz Posts: 2, Reputation: 10 Junior Member #2 Nov 28, 2011, 11:13 AM
In the LION's WINS column, use the IF function. IF(X>Y,Z+1,Z)
In this case:
X= LION's score (use the cell reference, such as "C11")
Y= PACKER's score (use the cell reference, such as "C12")
Z = the number of wins LIONS had last week (use the cell reference, such as "B18" in both places)

Note that the functiono can be read as "If X is greater than Y, enter value Z+1, else enter value Z)

Hope that helps.

## Check out some similar questions!

Formula to compute win/loss percentage [ 5 Answers ]

How do I compute win/loss percentage for the games we've played ?

win loss formula? [ 0 Answers ]

I am recording football scores. How do I get the sum to add 1 to the winning total when a team wins and vice versa when a team loses? Buffalo 24 13 opponent " 17 24 " Totals 1 1 thanks

I seek a private philanthropist to assist me for real estate investing. I have prior experience. I seek a win win situation. I have perfect credit and live in a great part of USA.

Calculate win loss For compare to score [ 0 Answers ]

Two cricket team is play test match if team A 1st innings score is 464 /6 (90 overs) Team B is play 1st innings to get score on 308/9. How to calculate the winning percentage

How to properly calculate win loss percentages in sports