+ Reply to Thread
Results 1 to 2 of 2

Need help with a contest formula

  1. 03-22-2013, 10:50 AM #1
    jgaffny
    jgaffny is offline
    Registered User
    Join Date
    02-26-2013
    Location
    Londonderry, New Hampshire
    MS-Off Ver
    Excel 2003
    Posts
    8

    Need help with a contest formula

    I put together (with the help of this forum, thank you) a calculator for a Sales contest. I want to set a # of calls for my sales team to make, and give them points for exceeding metrics.

    The formula currently gives 1 point for every call OVER the minimum required. HOWEVER, I would like to weight the points given for calls over minimum, and instead of 1 point give them .5 a point. How would i change the formula?

    Current formula is - =IF(D3="","",D3-C3)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-22-2013, 11:08 AM #2
    Brumbot
    Brumbot is offline
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2010
    Posts
    179

    Re: Need help with a contest formula

    Hi jgaffny,

    Please Login or Register  to view this content.
    Does this work? This says if D is greater than C, then work out the difference divided by 2 (half a point for each point over), if it isn't then just work out the difference.
    Did I help? Click *- add to my rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1