[Jackit]

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]

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.