Skip to content

Instantly share code, notes, and snippets.

@azizasm

azizasm/kwsp.xls

Last active April 13, 2024 06:22
Show Gist options
  • Save azizasm/2c40a93e98d68baa7fe24a016a3f1b76 to your computer and use it in GitHub Desktop.
Save azizasm/2c40a93e98d68baa7fe24a016a3f1b76 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. azizasm revised this gist Apr 13, 2024. 1 changed file with 4 additions and 0 deletions.
    4 changes: 4 additions & 0 deletions kwsp.xls
    View file
    Original file line number Diff line number Diff line change
    @@ -5,6 +5,10 @@ Salary Majikan Pekerja
    6000 720.00 660.00



    A2
    Enter salary

    B2
    =IF(A2>5000, CEILING.MATH(12/100*CEILING.MATH(A2/100)*100), CEILING.MATH(13/100*CEILING.MATH(A2/20)*20))

  2. azizasm revised this gist Apr 13, 2024. 1 changed file with 5 additions and 0 deletions.
    5 changes: 5 additions & 0 deletions kwsp.xls
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +1,5 @@
    # This formula can be used in Excel to calculate KWSP/EPF 2024 Employer and Employee

    A B C
    Salary Majikan Pekerja
    6000 720.00 660.00
    @@ -8,3 +10,6 @@ B2

    C2
    =CEILING.MATH(11/100* IF(A2>5000, CEILING.MATH(A2/100)*100,CEILING.MATH(A2/20)*20))


    # verify formula with table : https://www.kwsp.gov.my/documents/d/guest/jadual-ketiga-bm-pdf-1
  3. azizasm created this gist Apr 13, 2024.
    10 changes: 10 additions & 0 deletions kwsp.xls
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,10 @@
    A B C
    Salary Majikan Pekerja
    6000 720.00 660.00


    B2
    =IF(A2>5000, CEILING.MATH(12/100*CEILING.MATH(A2/100)*100), CEILING.MATH(13/100*CEILING.MATH(A2/20)*20))

    C2
    =CEILING.MATH(11/100* IF(A2>5000, CEILING.MATH(A2/100)*100,CEILING.MATH(A2/20)*20))