Please help me with how to calculate the monthly salary in Excel, and I need the formula to calculate the monthly salary.
Details of the Calculation
For 80 people, the monthly salary is 800 USD, which equals 2.26 USD per hour. Please help me out, it's very urgent.
Thanks,
Renita
From India, Bangalore
Acknowledge(0)
Amend(0)
Details of the Calculation
For 80 people, the monthly salary is 800 USD, which equals 2.26 USD per hour. Please help me out, it's very urgent.
Thanks,
Renita
From India, Bangalore
Acknowledge(0)Amend(0)
Net Paid Salary Calculation
Net paid salary can be calculated using the formula: net paid salary = (total salary / total days in the month) * total working days. According to your details, if the monthly salary is 800 USD, total days are 30, and total working days (present) are 20, then the net paid salary would be (800 USD / 30) * 20 = 533 USD.
Regards,
Akhil
From India, New Delhi
Acknowledge(0)Amend(0)
Net paid salary can be calculated using the formula: net paid salary = (total salary / total days in the month) * total working days. According to your details, if the monthly salary is 800 USD, total days are 30, and total working days (present) are 20, then the net paid salary would be (800 USD / 30) * 20 = 533 USD.
Regards,
Akhil
From India, New Delhi
Acknowledge(0)Amend(0)
Hello Everybody, I am looking for a formula and am totally stuck. Please help. I need to calculate the gross amount of salary for a list of employees that have a net salary guaranteed. This is the data:
Formula for Calculating Gross Salary
Gross - tax = net
Tax = ((taxable amount * tax rate) - deduction)
Taxable amount = (gross - 2000)
Tax rate = 5% if taxable amount is between 0.01 and 500; 10% if between 500.01 and 2000; 15% if between 2000.01 and 5000; 20% if between 5000.01 and 20000;...
Deduction = 0 if (taxable amount * tax rate) is between 0.01 and 500; 25 if between 500.01 and 2000; 125 if between 2000.01 and 5000; 375 if between 5000.01 and 20000;...
For the tax rate and the deduction, I have been using VLOOKUPs referring to the gross amount, but if I only know my net and have to look for my gross, it does not work. Hope it is clear, and somebody can help.
Regards,
Syed.
From India, Bangalore
Acknowledge(0)Amend(0)
1Formula for Calculating Gross Salary
Gross - tax = net
Tax = ((taxable amount * tax rate) - deduction)
Taxable amount = (gross - 2000)
Tax rate = 5% if taxable amount is between 0.01 and 500; 10% if between 500.01 and 2000; 15% if between 2000.01 and 5000; 20% if between 5000.01 and 20000;...
Deduction = 0 if (taxable amount * tax rate) is between 0.01 and 500; 25 if between 500.01 and 2000; 125 if between 2000.01 and 5000; 375 if between 5000.01 and 20000;...
For the tax rate and the deduction, I have been using VLOOKUPs referring to the gross amount, but if I only know my net and have to look for my gross, it does not work. Hope it is clear, and somebody can help.
Regards,
Syed.
From India, Bangalore
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
SALARY SHEET CALCULATION.xls
SALARY EXCEL.zip
Salary calculation.doc