Excel Formula for Increment Calculation Home › Forums › Excel Utility › 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 AnonymousInactive 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 AnonymousInactive 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. Log In Username: Password: Keep me signed in Log In