WBXPress

You must be logged in to ask question. If you are New here, Register first (free). Then Login.

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
  • #69828
    unknown
    Spectator

      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.

      #79963
      unknown
      Spectator

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

      Viewing 2 posts - 1 through 2 (of 2 total)
      • You must be logged in to reply to this topic.