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
    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.

    #79963
    Anonymous
    Inactive

    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.