Question description:
This user has given permission to use the problem statement for this
blog.
Hi, i need one formula, for example in salary level
200000 to 300000 is coming under 6B
300000 to 450000 is coming under 6A
450000 to 600000 is coming under 5A
Now if salary is 280000 so which formula i can use to find their Band lavel
Solved by E. F. in 35 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
02/04/2018 - 05:29
hi
User
02/04/2018 - 05:29
hi
Excelchat Expert
02/04/2018 - 05:30
Welcome to Excelchat
User
02/04/2018 - 05:30
thanks
User
02/04/2018 - 05:30
please suggest formula
Excelchat Expert
02/04/2018 - 05:30
Can i tell you a shortcut?
User
02/04/2018 - 05:30
ok
Excelchat Expert
02/04/2018 - 05:30
Not a formula exactly
Excelchat Expert
02/04/2018 - 05:31
Lets say
User
02/04/2018 - 05:31
ok
Excelchat Expert
02/04/2018 - 05:31
these salaries
Excelchat Expert
02/04/2018 - 05:31
Just sort then in ascending or decending order and get the range yourself
User
02/04/2018 - 05:31
ok
Excelchat Expert
02/04/2018 - 05:32
Can you do that?
Excelchat Expert
02/04/2018 - 05:33
It has been arranged in ascending order
Excelchat Expert
02/04/2018 - 05:33
So, the range is 45000-67000
User
02/04/2018 - 05:33
ok
Excelchat Expert
02/04/2018 - 05:33
There is one more way
Excelchat Expert
02/04/2018 - 05:34
The range is highlighted in the green
Excelchat Expert
02/04/2018 - 05:35
Did you get what i did here?
User
02/04/2018 - 05:35
no
Excelchat Expert
02/04/2018 - 05:35
In B&, i have used the MIN formula
Excelchat Expert
02/04/2018 - 05:35
it will return the lowest value in the given selected range
Excelchat Expert
02/04/2018 - 05:36
C7 i have used the MAX formula, it will return the max valu from the selected range
Excelchat Expert
02/04/2018 - 05:36
Are you following up with me?
User
02/04/2018 - 05:36
ok
User
02/04/2018 - 05:36
yes
Excelchat Expert
02/04/2018 - 05:36
Are you satisfied?
User
02/04/2018 - 05:36
no
Excelchat Expert
02/04/2018 - 05:37
Something missing?
User
02/04/2018 - 05:37
please wait 1 mins i will type in excel
User
02/04/2018 - 05:37
in salary level 200000 to 300000 is coming under 6B 300000 to 450000 is coming under 6A 450000 to 600000 is coming under 5A Now if salary is 280000 so which formula i can use to find their Band lavel
Excelchat Expert
02/04/2018 - 05:37
OK
Excelchat Expert
02/04/2018 - 05:38
OK you want that the band level is found automatically?
User
02/04/2018 - 05:38
yes
Excelchat Expert
02/04/2018 - 05:38
Cool
Excelchat Expert
02/04/2018 - 05:40
Wait
User
02/04/2018 - 05:40
ok
Excelchat Expert
02/04/2018 - 05:45
IT SHOULD RETURN THE VALUE
Excelchat Expert
02/04/2018 - 05:45
I guess there is some error
Excelchat Expert
02/04/2018 - 05:45
let me rectify
User
02/04/2018 - 05:45
ok
Excelchat Expert
02/04/2018 - 05:55
OK
Excelchat Expert
02/04/2018 - 05:55
SORRY for the delay
Excelchat Expert
02/04/2018 - 05:56
I think its done
Excelchat Expert
02/04/2018 - 05:56
Did you see what i did here?
Excelchat Expert
02/04/2018 - 05:57
Just remember, the condition should be given such that
Excelchat Expert
02/04/2018 - 05:57
In case you are using greater than condition, put the bigger number first, and smallest in the last.
Excelchat Expert
02/04/2018 - 05:58
Are you following mate?
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.