Cloud Payroll - Formula: Use of IF ELSE on Allowance

From AutoCount Resource Center
Jump to navigation Jump to search

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:

Formula if else 01.png



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:

Formula if else 02.png



Prepared by ChenOng 211021, Azirah 211025, P211026



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations