**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.*