+ Reply to Thread
Results 1 to 3 of 3

Assign different value based on goals

  1. #1
    Registered User
    Join Date
    09-01-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Assign different value based on goals

    I have 9 locations that I have to set goals for and track how close they come to their goals. So I have created a spreadsheet that In colum A I have a goal set that i need my entire territory to meet. In colum B I want to enter each locations actual ending number. I would like column C to assign specific points. If the location meets or exceeds their goal, I want the system to assign 20 points, if the location is 0.01% to 1.00% above goal, assign 15 points., 1.01% to 2.00% assign 10 points, and 2.01% or more above their goal assign 0 points.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,053

    Re: Assign different value based on goals

    Why not attach a sample workbook?

    When you are in Advanced reply, click on the paperclip to open the upload window.

    View Pic
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    09-01-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Assign different value based on goals

    Workbook is at my office and I am a home today. Example listed below
    Column A. Column B. Column C
    Goal. Actual. Points
    28%. 27.20%. 20
    28%. 28.50%. 15
    28%. 30.50%. 0

    Column A is updated automatically every month with the new goal. Column B I imported at month end showing their actual ending percent. I need column C to assign the correct points.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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