I do below 2 activities manualy for challans so pls let me know what formula to be put for pf pension fund
8.33% of basic <=6500 is 541.
if >=6500 then 541.
What is the correct formula to put in cell so that when pf salary is more then (a)6500 then 8.33% take 541 only.
(B) pf salary contribution from employer limit not higher then 6500- so for the same i need formula if employee's salary is higher then 6500 then also take 6500 only.
8.33% of basic <=6500 is 541.
if >=6500 then 541.
What is the correct formula to put in cell so that when pf salary is more then (a)6500 then 8.33% take 541 only.
(B) pf salary contribution from employer limit not higher then 6500- so for the same i need formula if employee's salary is higher then 6500 then also take 6500 only.