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
![]() |
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
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.
All times are GMT -7. The time now is 03:19 PM. |