+ Reply to Thread
Results 1 to 4 of 4

Formula Creation: Using List Function + Subtraction Function

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    Iowa
    MS-Off Ver
    Excel 2003
    Posts
    3

    Formula Creation: Using List Function + Subtraction Function

    Hi All,
    I need help with what I consider a complicated formula.

    I have two different scenarios, that I need put into a formula for entry on an invoice:
    There are two different commission minimum types ($200 & $50), correlating with two different business types (Permanent & Portable). I have created a workbook with 2 different spreadsheets. The first spreadsheet is the entry sheet with room for entry of gross sales and verified cash, outputting the net sales, and sales percentage based on attendance. These all pull into the printable invoice, with more calculated information.

    My question is this:
    Based on the business type (right now is a drop-down list), I need to create a formula subtracting the minimum ($200 or $50) from the commission amount, to give an accurate commission amount.

    Every permanent business is a $200 minimum and every portable is a $50 minimum, however I need to correlate this with the drop-down list, so it changes if the business changes...

    I hope someone followed this enough to help me!
    Thank you!

  2. #2
    Registered User
    Join Date
    04-09-2013
    Location
    Iowa
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Formula Creation: Using List Function + Subtraction Function

    Also, this says I'm using Office 2003, but I'm using Office 2007! Sorry...

  3. #3
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Formula Creation: Using List Function + Subtraction Function

    is it possible to upload a worksheet to get a better idea of what you want?....thanks
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  4. #4
    Registered User
    Join Date
    04-09-2013
    Location
    Iowa
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Formula Creation: Using List Function + Subtraction Function

    Unfortunately, I can't as the file is protected and the business won't allow it.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1