Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2012
    Location
    India
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need a Formula to plot employees within a range

    Hi All,

    We recently received the salary ranges for a set of employees at various levels. The range has the Min, Med and Max in seperate column.

    I have a list of employees with the levels and their salary. I need a formula which will let me know the position of the employees

    The logic is :
    If below Min of level and range - Below Min
    If Below Med of level and range - Between Min & Med
    if below Max of level and range - Between Med and Max
    Else - Beyond Max

    I have attached a sample excel for your reference. I need the formula in Cell c18.

    Hoping to receive a simple solution for the same.

    Regards
    Nethra
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Simple solution attached.

    I used a Named Range [Ranges] for the salary ranges to make the formula more readable - nested IF statements are always a bit of an eye test !

    Please test with your own values to make sure it is working exactly as you want - especially when the salary falls on the edge of a range, for instance EXACTLY AT the minimum.

    PS In your post you say you want the formula in C18, but on the Worksheet you say in column D ? I have put the formula in column D - you can move it if you need to.
    Attached Files Attached Files
    Last edited by MartinM; 2012-10-10 at 07:05.

  3. #3
    New Lounger
    Join Date
    Aug 2012
    Location
    India
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Martin,

    I was able to use this to map my people.

    Regards
    Nethra

Posting Permissions

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