Thread: Default Calculation Sales % From Multy Level Thanks: 0 Likes: 0

1. Default Calculation Sales % From Multy Level

Hi
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
Sheet1

Worksheet Formulas
Cell Formula
I3 =G3*H3
I4 =G4*H4
I5 =G5*H5
I6 =G6*H6
I7 =G7*H7
I8 =G8*H8
I9 =G9*H9
O3 =M3*N3
O4 =M4*N4
O5 =M5*N5
O6 =M6*N6
O7 =M7*N7
O8 =M8*N8
O9 =M9*N9
I13 =SUM(I3:I12)
O13 =SUM(O3:O12)

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

2. Re: Default Calculation Sales % From Multy Level

Hello any idea plz

3. Re: Default Calculation Sales % From Multy Level

is it hard case

4. Re: Default Calculation Sales % From Multy Level

i hope if any one can help