Results 1 to 3 of 3

Help needed to revise a formula

Threaded View

  1. #1
    Registered User
    Join Date
    05-01-2012
    Location
    UK
    MS-Off Ver
    Excel 2002
    Posts
    2

    Help needed to revise a formula

    Hi

    In need of some help to alter a formula in a sports (cricket) results template and I am not skilled enough to do it myself.

    I am using a spreadsheet to update a league table which was produced by someone else several years ago.
    Everything worked fine for the last couple of seasons, but there has been a rule change which affects the awarding of points.

    Previously, 12 points were awarded for winning a game (W) plus any batting or bowling bonus points earned (up to a maximum of 4 each) to make a maximum total of 20 possible for winning the match.

    Now winning sides automatically earn 20 points, irrespective of the number of bonus points they might have earned.

    What I want my formula to include is IF RESULT = W THEN BAT PTS MUST = 0 AND BOWL PTS MUST = 0.

    Therefore, the spreadsheet will award 20 result points and no bonus points, whereas currently it is awarding 20 result points plus bonus points. I have found the formulae to change the 12 to 20.

    Hope someone can help me out!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1