Results 1 to 4 of 4

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

  1. #1
    Board Regular
    Join Date
    Aug 2009
    Posts
    724
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #2
    Board Regular
    Join Date
    Aug 2009
    Posts
    724
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Default Calculation Sales % From Multy Level

    Hello any idea plz

  3. #3
    Board Regular
    Join Date
    Aug 2009
    Posts
    724
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Default Calculation Sales % From Multy Level

    is it hard case

  4. #4
    Board Regular
    Join Date
    Aug 2009
    Posts
    724
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Default Calculation Sales % From Multy Level

    i hope if any one can help

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •