Skip to content

Instantly share code, notes, and snippets.

@azizasm

azizasm/kwsp.xls

Last active April 13, 2024 06:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • 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
KWSP Excel formula
Raw
kwsp.xls
# 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
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))
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment