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
2What is the formula if Basic + DA is less or greater than 15000? Can anybody please answer me?
From India, Bangalore
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
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
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
From India, Kolkata
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)
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
From India, Thane
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
From India, Patna
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)
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
From India, Chennai
Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
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)