Cloud Payroll - 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:
Prepared by ChenOng 211021, Azirah 211025, P211026
AutoCount Accounting 1.8 / 1.9
|
AutoCount Payroll
|
AutoCount POS
|
AutoCount On The Go
|
AutoCount Accounting Plug-In Documentations
|