- This topic is empty.
Viewing 2 posts - 1 through 2 (of 2 total)
Viewing 2 posts - 1 through 2 (of 2 total)
- You must be logged in to reply to this topic.
Home › Forums › Excel Utility › Excel Formula for Increment Calculation
Use the following formula:-
=CEILING((INT(A1*0.03)),10)
for getting increment value only.
=CEILING((INT(A1*1.03)),10)
for getting new basic pay.
Replace A1 with the appropriate cell number.
Thanks for your guidance.
Waiting for Excel Utility of ”Salary Statement” for 50 employees.