 | |
| Browse | Ask | Answer | Search | Join/Login | |
win loss formula?
Asked Nov 24, 2011, 12:02 PM
—
1 Answer 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 |
1 Answer
| ||||
| 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. | ||||
| |
Not your question? Ask your question View similar questions
| Thread Tools | Search this Thread |
Add your answer here.
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
Seek philanthropist to assist with private financing. Win win situation [ 3 Answers ]
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 [ 1 Answers ]
How to properly calculate win loss percentages in sports
View more Accounting questions Search
