• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

Swapnilb003

New Member
Table-1
Status Salary Job RatingRating definition
Hourly>75000,<=900003,5 Very Good
Half-Time>10000,<=500001,3 Good
Full Time>20000<4 Average
Contract<900001,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.
 

Attachments

  • Test File.xlsx
    52.2 KB · Views: 4
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. :(
 
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 :)
 
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.
 
Back
Top