LearnMeExcel
Well-known Member
- Joined
- Aug 11, 2009
- Messages
- 746
- Office Version
- 365
- 2021
- Platform
- Windows
Hi
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
in column A B my Sales Table
From Range E2:G12 Sales % For Product A
From Range K2:M12 Sales % for Product B
in Column H & i how i calculate the % for Each Transaction
and same steps in Column N & O
it takes long time to calculate % for my sales
any Idea please to Make it easier than my way
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Product | Sales | A | A | B | B | ||||||||||
2 | A | 1326 | F | T | % | 1326 | F | T | % | 3365 | ||||||
3 | B | 3365 | 0 | 200 | 0% | 200 | 0 | 0 | 500 | 0% | 500 | 0 | ||||
4 | A | 441 | 201 | 400 | 0.50% | 200 | 1 | 501 | 1000 | 0.50% | 500 | 2.5 | ||||
5 | A | 622 | 401 | 600 | 0.75% | 200 | 1.5 | 1001 | 1500 | 0.75% | 500 | 3.75 | ||||
6 | B | 7955 | 601 | 800 | 1% | 200 | 2 | 1501 | 2000 | 1% | 500 | 5 | ||||
7 | B | 5435 | 801 | 1000 | 1.25% | 200 | 2.5 | 2001 | 2500 | 1.25% | 500 | 6.25 | ||||
8 | A | 538 | 1001 | 1200 | 1.50% | 200 | 3 | 2501 | 3000 | 1.50% | 500 | 7.5 | ||||
9 | 1201 | 1400 | 1.75% | 126 | 2.205 | 3001 | 3500 | 1.75% | 365 | 6.3875 | ||||||
10 | 1401 | 1600 | 2% | 3501 | 4000 | 2% | ||||||||||
11 | 1601 | 1800 | 2.25% | 4001 | 4500 | 2.25% | ||||||||||
12 | 1801 | 3% | 4501 | 3% | ||||||||||||
13 | total commision for 1st inovice | 12.205 | total commision for 2st inovice | 31.3875 | ||||||||||||
14 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>
in column A B my Sales Table
From Range E2:G12 Sales % For Product A
From Range K2:M12 Sales % for Product B
in Column H & i how i calculate the % for Each Transaction
and same steps in Column N & O
it takes long time to calculate % for my sales
any Idea please to Make it easier than my way