+ Reply to Thread
Results 1 to 7 of 7

Calculate commission against target

  1. #1
    Registered User
    Join Date
    12-10-2020
    Location
    Wilmington, NC
    MS-Off Ver
    2018
    Posts
    6

    Calculate commission against target

    Would anyone know what formulas to use to make this spreadsheet work? Following the description so that if Column A is changed the whole spreadsheet would fluctuate and still be correct to those numbers?

  2. #2
    Registered User
    Join Date
    12-10-2020
    Location
    Wilmington, NC
    MS-Off Ver
    2018
    Posts
    6

    re: Calculate commission against target

    I am new so can post post link until i post a few ties. Will add when i can

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,327

    re: Calculate commission against target

    Hi there. You CAN post a file, but can not Yet post links to external file-hosting sites.


    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  4. #4
    Registered User
    Join Date
    12-10-2020
    Location
    Wilmington, NC
    MS-Off Ver
    2018
    Posts
    6

    re: Calculate commission against target

    should now be posted
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    12-10-2020
    Location
    Wilmington, NC
    MS-Off Ver
    2018
    Posts
    6

    re: Calculate commission against target

    now posted thank you!

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,327

    Re: Calculate commission against target

    Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

    A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

    Since you are a new user of this site, on this occasion, I have changed it for you.

    However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

    *Other search engines are available!!!

    Regards,

    Glenn.

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,327

    Re: Calculate commission against target

    I think you need to explain a bit more about what is entered manually and where... and what you expect to be calculated by Excel. I'm not clear what you want.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Commission Calculator ( % to target with variable % pay rate)
    By firefuze in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-19-2013, 06:06 PM
  2. calculate commission
    By neorez in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-05-2013, 05:38 AM
  3. Calculate commission
    By DAVIDJMORIN in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-31-2011, 10:56 AM
  4. Calculate commission
    By pansovic in forum Excel General
    Replies: 6
    Last Post: 06-07-2010, 02:14 PM
  5. Calculate commission - IF AND ??
    By tc123 in forum Excel General
    Replies: 3
    Last Post: 12-08-2007, 09:12 AM
  6. calculate commission $ based on total sold and commission percent
    By blondeindenver in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2005, 10:05 PM

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