Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jul 2006
    Location
    Bangalore, India
    Posts
    180
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi Excel Experts,

    I am working on a increase % matrix for my employee. I have attached an excel that would help.

    I have the employees spread in 5 bands RPO1,RPO2,RPO3,RPO4,RPO5
    The employee fall with a specific salary range
    10.00% - 84.99%
    85.00% - 94.99%
    95.00% - 104.99%
    105.00% - 114.99%
    115.00%+

    - I have the % spread of employee in this range entered manually i.e. column K
    Column I has the desired % spread of employee in the 5 bands mentioned above
    Target % Increase is in Column.

    Is it possible through a formula in the cells shaded GREY Column E-G to arrive at the Target %'s in Column L. At the moment im doing it manually to somehow get it close to the Target

    Hope to have a positive response. This is save a lot of my time/effort to arrive at the Target manually

    Regards
    Baiju
    Attached Files Attached Files

  2. #2
    2 Star Lounger
    Join Date
    Jul 2006
    Location
    Bangalore, India
    Posts
    180
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi Excel Experts,


    I havent heard any solutions for this, is this possible with a formula.

    Regards
    Baiju

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post
    Quote Originally Posted by Baiju G Nath View Post
    Hi Excel Experts,


    I havent heard any solutions for this, is this possible with a formula.

    Regards
    Baiju
    Baiju

    You may want to have a look at this post in the WS Lounge
    Jerry

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    No formula solution, but since you cross-posted, there is a solution posted here

    Steve

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Chicago, Illinois, USA
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Can you explain through example what you're trying to accomplish? I think I'm just a little thick-headed this morning.

Posting Permissions

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