Use the IF Function to categorize candidates as below:
Experience 2 years "Medium Experience"
Experience 4 years "Highly Experienced"

Use IF & AND Function to categorize candiates as below:
Male candidate with Experience 2 years "Medium Experience -
Male"
Male candidate with Experience 4 years "Highly Experienced -
Male"
Female candidate with Experience 2 years "Medium Experience -
Female"
Female candidate with Experience 4 years "Highly Experienced -
Female"
Table has the following field names:
S. No., Name, Sex, Qualification, Experience (Yrs), Blood group, DOB, Date
of Joining.

Perhaps you need to do some background reading before you start your
homework? There are some useful Excel tutorials available, which Google
will find for you, and plenty of beginners' books on the market.

If you have a specific question, tell us what formula you've tried, what
input data gave what result, and what result you expected.
--
David Biddulph

"Sanjib" wrote in message
...
Use the IF Function to categorize candidates as below:
Experience 2 years "Medium Experience"
Experience 4 years "Highly Experienced"

Use IF & AND Function to categorize candiates as below:
Male candidate with Experience 2 years "Medium Experience -
Male"
Male candidate with Experience 4 years "Highly Experienced -
Male"
Female candidate with Experience 2 years "Medium Experience -
Female"
Female candidate with Experience 4 years "Highly Experienced -
Female"
Table has the following field names:
S. No., Name, Sex, Qualification, Experience (Yrs), Blood group, DOB, Date
of Joining.