A3.186 : Formula: Use of IF ELSE on Allowance
Question : Formula: Use of IF ELSE on Allowance
How to use IF ELSE condition in allowance formula?
Scenario 1:
To set Attendance Allowance to be prorated based on employee working days
If employee had full attendance, he gets RM 100. Else, the allowance will be prorated based on worked days.
You can set formula like:
Scenario 2:
To set Allowance to be given on specific Employee Group.
If employee is Management Level of employee group, he will get RM200, else will be 0.
You can set formula like:
--Source from AutoCount Wiki --
Related Articles
A3.254 : Allowance formula not captured correctly
Question : I have created an Allowance Formula using unpaid leave but after processed payroll, the value of Allowance is not captured correctly. Unpaid leave record gets from ESS leave application. Possible Reason : Unpaid leave formula was taken ...A3.188 : Formula: How to set lateness formula using IF ELSE function in deduction?
Question : How to set lateness formula using IF ELSE function in deduction? Answer 1) Go to Tools > Deduction> 2) Click on Add New button 3) Maintain Deduction Code, Description and determine the statutory setting. Then click on Formula to set your ...A3.184 : Payroll : How to set the exceeded Overtime hour transfer to allowance using fixed rate per hour?
Question : I have set limit Overtime hour to 104 hour. How to set the exceeded Overtime hour transfer to allowance with the same rate of 1 hour = RM 5.00? Answer : You must create a new Allowance code and set an allowance formula for that purpose. 1) ...A3.84 : How to change unpaid leave daily rate formula?
Question : How to change unpaid leave daily rate formula? Effective 01st January 2023, Malaysia government has suggested the formula to calculate employee’s unpaid leave by using All Days in Calendar. You are advised to make the following payroll ...A1.66 : How to set the formula with Operators (If)
Question : My Unit price is calculated using formula = d_UDF_UP * d_UDF_W * d_UDF_H. But sometimes the value of UDF is empty, it causes the Unit price becomes 0. How can I set the Formula, so that when the value of UDF is null, it will be counted as ...