Results 1 to 5 of 5

Help with Formula to calculate the basket total and add commission

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-17-2014
    Location
    london
    MS-Off Ver
    365
    Posts
    398

    Help with Formula to calculate the basket total and add commission

    Dear All

    I was hoping someone can help me with a formula: I have attached an example excel sheet to illustrate what I Want to achieve
    In the attached file I need to create a formula so that:

    group all the same order names and sum the product price for that order, and then *1.9% and add .2

    so for example for order name #1333 it should add all the product prices for #1333 (i.e.b7:b13) then multiply the sum by 1.9% and then add 0.2 to the answer. Basically the order names with the same value is one basket and what I need to do is sum the product prices for that basket and multiply it by 1.9% and add 0.2 for each basket.

    This is to calculate the commission we are being charged: 1.9% per transaction + 20p per basket, and my actual file has over 800 lines and some of them have same Order name which means it is all in one basket and I only have to add the 0.2 to a basket total and not for each line. I have highlighted each basket with different colours in my attached sheet.

    Im not sure this needs a Formula or Pivot

    Any Help is appreciate it
    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. [SOLVED] Trying to Calculate a Tiered Commission System within one formula
    By ppilot in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-19-2020, 01:23 AM
  2. [SOLVED] I need a formula to calculate the commission per trade of my broker
    By sigma_ in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-06-2018, 02:11 PM
  3. [SOLVED] Formula to calculate tiered commission/bonus
    By shrijan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-27-2017, 08:44 AM
  4. Simple Q - how to calculate total commission made by each Sales Perosn
    By biscan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-11-2015, 04:33 PM
  5. Replies: 4
    Last Post: 02-08-2014, 12:44 PM
  6. [SOLVED] Formula to Calculate commission over certain amount
    By rizmomin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2014, 02:36 PM
  7. 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