Functions

S

Sanjib

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

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top