Formula To Calculate Salary - Xls Download

Renita_De Silva
Hello,
Please help me how to calculate monthly salary in excel and i need formula to calculate the monthly salary.

The details is as follows,

For 80 people monthly salary is 800USD=2,26USD p.hour
Please help me out,, its very urgent,,,
Thanks
Renita
akhil_apex
net paid salary=(total salary/Total days in month)*total working days
acc to your details ...if monthlyb salary is 800usd,,if total days are 30,total working days (present) are 20
then net paid salary is (800usd/30)*20=533 usd.
Akhil
syed149149@gmail.com
Hello Everybody,
I am looking for a formula and am totally stuck. Please help...
I need to calculate the gross amount of salary of a list of employees that have a net salary guaranteed.
This is the data :
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 20001.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 20001.01 and 5000; 375 if between 5000.01 and 20000;...
For the tax rate and the deduction I have been using Vlookups refering 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
syed.
M.Sayeed
Syed,
Kindly go thro attachement, may be it will assist you,
Thanks,
1 Attachment(s) [Login To View]

royal.singhwani
Hello Friends ....
can somebody please tell me that what are the important points which an MBA fresher should be aware of while giving interview .....
like how to calculate salary?
or it could be calculation about gratutity ????
i have just completed MBA so would be glad if answer this question asap ......plzzzzz
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute