EXCEL FORMULA | SALARY CALCULATION FORMULA

 

FORMULA  :- 

P.F KA  :-  =SUM(C4*34%)

INCOM TAX KA :-  =SUM(C4*12.5%)

HOME  KA :-  =SUM(C4*11%)

MEDICAL KA :-   =SUM(C4*8%)

EDUCATION  KA :-   =SUM(C4*6%)

OTHER  KA :-  =SUM(C4*4%)

TOTAL MONTHLY PAYMENT  KA    =C4-(D4+E4)+(F4+G4+H4+I4)ENTER