Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=19)
-   -   Win loss formula? (https://www.askmehelpdesk.com/showthread.php?t=614503)

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

  • All times are GMT -7. The time now is 03:19 PM.