This guide will assist you in using the IF ELSE condition in allowance formula.
Scenario 1: To set Attendance Allowance to be a prorated based on employee working days If an employee has full attendance, he gets RM 100. Else, the allowance will be prorated based on worked days. Users may set a formula like this,
EXAMPLE:
IF (WORKING DAYS = WORKED DAYS) 100 ELSE (WORKED DAYS / WORKING DAYS x 100)
Scenario 2: To set Allowance to be given on specific Employee Group
If an employee is a Management Level of the employee group, he will get RM200, else will be 0. User may set a formula like this,
EXAMPLE:
IF (Employee Group Equal By MANAGEMENT LEVEL) 200 ELSE 0
END OF GUIDE