Jackit
Nov 24, 2011, 01:02 PM
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
Nov 28, 2011, 12:13 PM
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.