If Formula In Pf Calculation
Advance Search Feature
Available Downloads - Page 1
Search Result For "If Formula In Pf Calculation" - Page 1
Hi all,Advance Happy New Year to all. My friend has been working in a private company for 3 years. He wants to withdraw half the amount of PF for his marriage expenses. Is this possible? If so, what is the procedure to apply for the amount? Please explain to me....
If you want to fix $780 as the standard PF deduction for all, irrespective of their basic amount, then try this formula: =IF(C2 <= 6500, C2 * 12%, 780).Using this formula, you will have a 12% deduction on the basic amount if it is less than $6500\. For any amoun...
Dear Basha.786,You can adopt any one formula as mentioned below (both are correct):"=IF(Basic >= 6500, 6500*12%, Basic * 12%)"or"=IF(Basic <= 6500, Basic * 12%, 780)"Thanks & Regards,Subhra Bhattacharya.
Basic Rs.25,000 in Column C2\. Then, "=IF(C2 >= 6500, 6500 * 12%, Basic * 12%)" = 780.
So it comes like this:=IF(C2 <= 6500, 6500*12%, C2*12%)C2 stands for the basic salary of the employee. C2 equals a basic salary of 25,000 Rs. However, in the PF deduction column, it is showing 3000 Rs.How should it come to 780 Rs?
Use Excel (xls) IF condition: "=IF(Basic <= 6500, 6500*12%, Basic*12%)" - with this function, if the basic amount is less than or equal to 6500, the Provident Fund (PF) contribution will be 12% of 6500; otherwise, if the basic amount is greater than 6500, the co...
Hello all,I request your help with the calculation formula below:- If the basic is greater than or equal to 15K, then calculate 12%.- If the sum of basic and special allowance is less than the minimum wage of 13624, then calculate 12% of the minimum wage.- If bo...
In the context of PF calculation in Bengaluru, India, the formula provided outlines specific scenarios for determining the contribution based on the basic salary and special allowance in relation to the minimum wage and the 15K threshold. Here is a practical bre...
Whose basic salary is 35000, and he wants to adopt the minimum PF contributions on the maximum PF limit of Rs. 15000, so it's Rs. 1800/-. If he presents for 7 days out of 26 days, then how much PF is deducted from his salary. If he presents for 15 days out of 26...
If the PF is restricted to 12% on Rs 15,000, then 15,000 should be taken as wages, and any deduction for absence should be made from 15,000\. Then only the contribution will equate to the number of days present. Therefore, if the employee has worked only for 7 d...