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
From India, Bangalore
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
From India, Bangalore
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
From India, New Delhi
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
From India, New Delhi
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.
From India, Bangalore
1I 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.
From India, Bangalore
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
From India, Kanpur
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
From India, Kanpur
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
CB- Salary Structure Formula.xls