Calculate the commission for different sellers on the same product
Solved
LauCar
-
Raymond PENTIER Posted messages 58551 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58551 Registration date Status Contributeur Last intervention -
Hello. Here is my question:
I created a list in tab 1: the product and the sales percentage each seller 1, seller 2, and seller 3 makes on this product. I scrolled down my entire list.
Example:
Column A Column B Column C Column D
PRODUCT Seller A Seller B Seller C
Product A 2% 1% 3%
Product B 1% 3% 2%
Product C 3% 2% 1%
In tab 2, I want the commission calculation for each seller to be done automatically based on the sold product which would be written here in column A (and which would match a product listed in column A of tab 1). In column B, I would have the selling price and in columns C-D and E, the 3 sellers each making a different percentage based on the sold product.
Example
Column A Column B Column C Column D Column E
PRODUCT PRICE SELLER A SELLER B SELLER C
Product A 10$ =???
Product B 15$
Product A 10$
Product C 20$
I am wondering what formula I should enter in each seller's column!
I created a list in tab 1: the product and the sales percentage each seller 1, seller 2, and seller 3 makes on this product. I scrolled down my entire list.
Example:
Column A Column B Column C Column D
PRODUCT Seller A Seller B Seller C
Product A 2% 1% 3%
Product B 1% 3% 2%
Product C 3% 2% 1%
In tab 2, I want the commission calculation for each seller to be done automatically based on the sold product which would be written here in column A (and which would match a product listed in column A of tab 1). In column B, I would have the selling price and in columns C-D and E, the 3 sellers each making a different percentage based on the sold product.
Example
Column A Column B Column C Column D Column E
PRODUCT PRICE SELLER A SELLER B SELLER C
Product A 10$ =???
Product B 15$
Product A 10$
Product C 20$
I am wondering what formula I should enter in each seller's column!
Liens connexes:
- Excel copy the same date in an entire column
- Calculation of monthly sales for a product.
- Calculation of the number of months (even incomplete) between two dates
- Product if not equal to zero
- Two Excel tables on the same page, freeze one.
- Calculation of the control key for a French National Identity Number (NIR) in Corsica (2A or 2B)
2 réponses
Hello.
In C2 enter the formula
=$B2*VLOOKUP($A2;sheet1!$A$2:$D$4;COLUMN()-1;0)
and copy it down to E5
--
It's great, retirement! Especially in the Antilles...
Raymond (INSA, AFPA)
In C2 enter the formula
=$B2*VLOOKUP($A2;sheet1!$A$2:$D$4;COLUMN()-1;0)
and copy it down to E5
--
It's great, retirement! Especially in the Antilles...
Raymond (INSA, AFPA)