Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.