Results 1 to 19 of 19

Help with Commission calculations

Threaded View

  1. #13
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Help with Commission calculations

    Sorry, typo
    Formula: copy to clipboard
    =MIN(1500, F2-150)*0.35 +MAX(0, F2-150-1500)* IF(E2="A", 0.5,0.4)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sales Commission calculations
    By Kevin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  2. Sales Commission calculations
    By Kevin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  3. [SOLVED] Sales Commission calculations
    By Kevin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 AM
  4. Sales Commission calculations
    By Kevin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  5. [SOLVED] Sales Commission calculations
    By Kevin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. [SOLVED] Sales Commission calculations
    By Kevin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. Sales Commission calculations
    By Kevin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. Sales Commission calculations
    By Kevin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-25-2005, 12: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