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