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