Cloud Payroll - Formula: Use of IF ELSE on Allowance

From AutoCount Resource Center

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:



Prepared by ChenOng 211021, Azirah 211025, P211026



Go to menu

AutoCount Accounting 2.0 & 2.1


AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS


AutoCount On The Go
AutoCount Accounting Plug-In Documentations