How to Calculate DA on Basic Salary in Excel (3 Easy Ways)

We’ll use the following dataset, which contains basic employee information, including Name, Salary, Total Days, and Worked Days.

We’ll start with a basic dataset for employee names and their salaries.

Steps:

=IF(C5>=7000,"8%","7%")

If the salary is greater than or equal to $7,000, the function will return the DA percentage as 8%. Otherwise, it will return 7%.

Drag the Fill Handle icon to AutoFill the corresponding data in the cells D5:D9.

=C5*D5

We have multiplied the Salary range by the DA Percentage to get the final DA Amount.

Press Enter to get the DA Amount.
Drag the Fill Handle icon to AutoFill the corresponding data in the rest of the cells E5:E9.

We’ll use the expanded dataset with four columns: Name, Salary, Total Days, and Worked Days.

Steps:

=IF(E5=0,"",ROUND(C5/D5*E5*7%,-1))

Formula Explanation

E5=0: this is the condition of the IF Function.
“”: When the IF condition satisfies, it will return a blank cell.
ROUND(C5/D5*E5*7%,-1): When the IF function does not satisfy it will round the DA value of to the decimal figure.
IF(E5=0,””,ROUND(C5/D5*E5*7%,-1)): It will check if the Worked Days value equals to 0 to return the DA amount. If the worked days equal to 0, it will return the DA amount as a space otherwise it will return the DA amount