Understanding Nested IF Statements for Calculating Employee Payables on the Keka Portal

When calculating payables in Keka, you can use formulas to automate and customize salary component calculations. Follow the Standard JavaScript notation and the BODMAS (Brackets, Orders, Division, Multiplication, Addition, Subtraction) rule for accuracy.

Writing Formulae

Use * for multiplication and / for division.
Enclose component names in square brackets, for example, [CTC] * 0.10.
Perform all arithmetic operations outside the brackets.

Using Nested IF Statements

Nested IF statements help apply conditions for different pay scales or logic-based calculations.

Syntax:

=IF(condition1, result1, IF(condition2, result2, IF(condition3, result3, ...)))

Example: Calculating petrol allowance based on employee CTC
=IF([CTC]<1000000, 0, IF([CTC]<2500000, 120000, IF([CTC]<4000000, 180000, 240000)))

Explanation:

If CTC is less than 10,00,000, the petrol allowance is 0.
If CTC is between 10,00,000 and 24,99,999, the petrol allowance is 1,20,000.
If CTC is between 25,00,000 and 39,99,999, the petrol allowance is 1,80,000.
If CTC is equal to or greater than 40,00,000, the petrol allowance is 2,40,000.

By applying formulas and nested IF statements correctly, you can automate complex payroll calculations and maintain consistency across employee pay structures.