If the amount is equal to 15000, then we use the formula = sum(Basic + DA) * 12% in the salary statement or payroll statement in Excel.
What is the formula if Basic + DA is less or greater than 15000? Can anybody please answer me?
From India, Bangalore
Acknowledge(0)
Amend(0)
3What is the formula if Basic + DA is less or greater than 15000? Can anybody please answer me?
From India, Bangalore
Acknowledge(0)Amend(0)
Hi,
If the amount is equal to 15000, then we use the following formula in the salary statement or payroll statement in Excel: = SUM(Basic + DA) * 12%.
What is the formula if Basic + DA is less or greater than 15000?
Can anybody please answer me?
I found the answer to this question. Here it is: = IF(SUM(D3, E3) >= 15000, 1800, SUM(D3, E3) * 12%)
From India, Bangalore
Acknowledge(0)Amend(0)
0
0
If the amount is equal to 15000, then we use the following formula in the salary statement or payroll statement in Excel: = SUM(Basic + DA) * 12%.
What is the formula if Basic + DA is less or greater than 15000?
Can anybody please answer me?
I found the answer to this question. Here it is: = IF(SUM(D3, E3) >= 15000, 1800, SUM(D3, E3) * 12%)
From India, Bangalore
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The formula provided is incorrect. The correct formula for EPF calculation when Basic + DA is less than or equal to 15000 should be: = (Basic + DA) * 12%. Thank you for your input.
0
0
Dear Sir, One of my friend is working as Security Guard. He is paid on daily basis. The security agent deduct PF from his salary. Please tell me how he will calculate PF against his salary
From India, Kolkata
Acknowledge(0)Amend(0)
0
0
From India, Kolkata
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The calculation of PF for a daily wage worker like a Security Guard involves multiplying the daily wage by the PF contribution rate (usually 12%). This determines the PF deduction per day. It's essential to ensure compliance with labor laws on PF deductions. (1 Acknowledge point)
0
0
Hi, i worke in Pvt.company last 5.5 year my PF was cut in my salary Rs.865 so how much Rupees i got.
From India, Thane
Acknowledge(1)
Amend(0)
0
0
From India, Thane
Acknowledge(1)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user's reply is incorrect. The calculation of EPF withdrawal involves various factors like employer contribution, interest, and service period. It's advisable to consult the EPF office or HR for the accurate amount.
0
0
Sure, I can help you with that! Please send me the scanned assignment so that I can understand exactly what you need. You are looking for formulas for DA, TA, HRA, Spl. Allow, EPF, HRD, and Tax. I will assist you in explaining the Excel assignment to the students. Thank you for reaching out.
From India, Patna
Acknowledge(0)Amend(0)
0
0
From India, Patna
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The request seems to be for assistance with an Excel assignment involving formulas for various components like DA, TA, HRA, Special Allowance, EPF, HRD, and Tax. Please provide the specific details or formulas needed for each component to ensure accurate assistance. Thank you for seeking clarification. (1 Acknowledge point)
0
0
salary slip headwise detail rules
From India, Uran
Acknowledge(0)Amend(0)
0
0
From India, Uran
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user reply does not align with the original post's request for an Excel file with EPF calculation formulas. Please provide the requested information.
0
0
if basic wage is more then 6500 we should pay 5** something,is there any possible to pay less then that ceiling amount
From India, Chennai
Acknowledge(0)Amend(0)
0
0
From India, Chennai
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user's reply is incorrect. According to the EPF Act, if an employee's basic wage exceeds INR 6,500, the employer and employee each contribute 12% of the basic wage, not 5%. There is no provision to pay less than the ceiling amount.
0
0
=IF(Pf Gross Salary)>15000,15001,(PF gross Salary)*12% pf gross salary means basic, ca, cca, special allowance. this is pf formula for 1800 max cap formula. it is very help full to all
From India, Mumbai
Acknowledge(0)Amend(0)
0
0
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The provided formula has some errors in syntax and logic. The correct formula for EPF calculation involves specific percentages based on the employee's wages. Please refer to EPF Act 1952 for accurate calculations.
0
0
Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Induction procedure points.doc
Procedure to be followed by employer in case of suppression - SC 21.7.2016.pdf
HOW HRIS HELPS IN INDUCTION PROCEDURE OF A.pps
CiteHR.AI
(Fact Checked)-The EPF contribution formula is =IF(Basic+DA<=15000, (Basic+DA)*12%, 1800). This ensures compliance with EPF regulations. (1 Acknowledge point)