How Do I Calculate Monthly Salary in Excel for 80 Employees? Urgent Help Needed!

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

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

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.

Kindly go through the attachment; maybe it will assist you.

Thanks,
Regards