Formula Fields can be complicated sometimes. So, here are examples that will help you understand the usage of these types of fields in Zoho Recruit.

1. IF ELSE Statement Example: If field name contains 'Golf Only 1 Meal', then return 265 ; Else if field name .contains 'Golf Only 2 Meals' return 295 else if field name contains 'Single Occ' return 665 or return 0
   Formula: If(Contains(${Contacts.fieldname}, 'Golf Only 1 Meal'),265,If(Contains(${Contacts.fieldname},'Golf Only 2 Meals'),295,If(Contains(${Contacts.fieldname},'Single Occ'),665,0 ) ) )
2. Example: 
   A manually entered Level; say A,B,C
   A manually entered File Received Date (Start Date)
   A formula field, that calculates a deadline date, based on the level and the File Received Date fields. This is called ''due date''.
   The calculation for Due Date -
   • If ''Level'' = A then the ''Due Date'' = ''File Received Date'' + 14 days
   • If ''Level'' = B then the ''Due Date'' = ''File Received Date'' + 10 days
   • If ''Level'' = C then the ''Due Date'' = ''File Received Date'' + 5 days

   Formula: If(Contains(${Candidates.level},'A'),Adddate(${Candidates.Start Date},14,'DAY'),If(Contains(${Candidates.level},'B'),Adddate(${Candidates.Start Date},10,'DAY'),If(Contains(${Candidates.level},'C'),Adddate(${Candidates.Start Date},5,'DAY'),Now())))

3. Example: To calculate the age based on the Date of Birth details.

   Formula:

   • Age in Years =
     Year(Now())-Year(${Candidates.DOB})- If(Month(Now())*100+Dayofmonth(Now())>=Month(${Candidates.DOB})*100+Dayofmonth(${Candidates.DOB}) ,0 ,1 )
   • Age in Months = (Datecomp(Now(),${Candidates.DOB}))/(60*24*30)
      
4. Change the return type of the drop-down value as a number and calculate the values of two or more drop-down fields.
   Note that the drop-down values are considered as string values, and not number values.

   Example: 
   Drop-down 1 Values - 10, 20, 30
   Drop-down 2 Values - 5, 10, 15
   Formula (number) field needs to calculate - (Drop-down 1*Drop-down 2)+Drop-down 2

   Formula: 
   (Tonumber(Drop-down 1)*Tonumber(Drop-down 2))+Tonumber(Drop-down 2)
   Return Type: Number