Facing nesting error and could not find where it is getting wrong. please advise.

[Swapnilb003]

Table-1
Status	Salary	Job Rating	Rating definition
Hourly	>75000,<=90000	3,5	Very Good
Half-Time	>10000,<=50000	1,3	Good
Full Time	>20000	<4	Average
Contract	<90000	1,3	Need Improvemen
Rest			Poor

Attaching a data wherein in Column "I" rating definition to be obtained. There are two more question for which I would require help from you experts.

 

[Luke M]

This seems like a poorly built table. For instance, what if someone is Full Time, with high salary, but scored a 5? For that matter, there appears to be no way for a Full Time person to get anything besides "Average" or "Poor".

Q2 is much easier, where when given number 1-12, to get the month name is: =TEXT(DATE(1, J7, 1), "mmmm")

Q3 is also odd. Seems like it wants you to insert spaces into the sentence, but it's somewhat random placement.

If this is some sort of XL assessment quiz, it's not a very good one.

 

[Swapnilb003]

This seems like a poorly built table. For instance, what if someone is Full Time, with high salary, but scored a 5? For that matter, there appears to be no way for a Full Time person to get anything besides "Average" or "Poor".

Q2 is much easier, where when given number 1-12, to get the month name is: =TEXT(DATE(1, J7, 1), "mmmm")

Q3 is also odd. Seems like it wants you to insert spaces into the sentence, but it's somewhat random placement.

If this is some sort of XL assessment quiz, it's not a very good one.

Thank you Luke.. the table is bit incomplete but its much to do with assessing the skills(is what they say). The last one indeed was something out of XL world. So really can't break head on that

 

[Luke M]

Working with what we have, you could solve Q1 a little easier then by using some OR/AND functions. That'll help you get around any nested function limits.

 

[Swapnilb003]

Hi Luke, thank you for your support. I was been able to resolve the first question as well