Formula : How do I use IF ELSE condition in allowance formula?

Created by Auto Count Support, Modified on Fri, 18 Apr at 12:01 PM by Auto Count Support

Print

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


 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article