Forum of wbxpress.com
WBXPRESS › 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.