Excel Formula for Increment Calculation

This topic is empty.

Viewing 2 posts - 1 through 2 (of 2 total)

Author

Posts
November 3, 2014 at 3:20 pm #69828

Anonymous
Inactive

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.

November 5, 2014 at 1:54 pm #79963

Anonymous
Inactive

Thanks for your guidance.
Waiting for Excel Utility of ”Salary Statement” for 50 employees.
Author

Posts

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.