Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: urgent need help  (Read 2342 times)

0 Members and 1 Guest are viewing this topic.

703071053

    Topic Starter


    Newbie

    • Experience: Beginner
    • OS: Windows 7
    urgent need help
    « on: August 07, 2015, 06:50:39 AM »

    Hi sir/madam


    Hi need urgent help for excel formula. I have data from cell A2 to A11 and I want that top 35% will get $4000.00. and next 35% will get $2000.00. and rest 30% will get $5000.00 in cell B2 to B11.


    Please help me urgent


    Kind regards
    Vinod

    DaveLembke



      Sage
    • Thanked: 662
    • Certifications: List
    • Computer: Specs
    • Experience: Expert
    • OS: Windows 10
    Re: urgent need help
    « Reply #1 on: August 07, 2015, 07:41:44 AM »
    Please clarify this better... what cells exactly get what percentages for column A2 through A11


    With 35%, 35%, and 30% of 10 cells you have 3 cells for your 30% and 7 cells for 2 x 35% for the 70% remainder in which you have a cell that overlaps the 2 groups for 2 different monetary amounts, which makes no sense.

    soybean



      Genius
    • The first soybean ever to learn the computer.
    • Thanked: 469
    • Computer: Specs
    • Experience: Experienced
    • OS: Windows 10
    Re: urgent need help
    « Reply #2 on: August 07, 2015, 09:46:48 AM »
    Yes, more info is needed.   Is the data in A2 through A11 sales by salesman?  Are the percentages supposed to be based on total sales of all sales people?  If so, what cell contains the grand total of sales?  If not, please clarify.