In the attached, excel sheet I wanted the calculation of tax each month to be auto calculated which would be calculated unless the salary is increased or decreased. If the salary is increased or decreased in a month for eg May the tax calculation changes over twelve month changing the amount in past months too. As I need it to be calculated in a single page but for every month along with changes in the amount
Your attached file has an invalid extension. Please revise.
deleted. thx Ali.
Last edited by Sam Capricci; 10-31-2018 at 07:56 AM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Sam - the other thread has already been closed as a duplicate.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Once downloaded, just delete the .xls section and the file will open fine. It's the forum that seems to add the double extension with some files.Originally Posted by xjohnson
Thank you very much for your support
You have 131 columns of data.... and one row. You need to tell us where to look AND what your manually calculated results are. More than a single, lonely row would help, too.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
I have already linked a percent calculation but when I put the salary in the month of Salary section it will calculate tax for all month cell. in this I need to do when salary increase in the month it calculate for whole month.
For Eg:
Jan Feb Mar(Increase salary and obviously increase in tax) Apr to Dec
Tax 10000 10000 15000 15000 15000
In this case I need when I change salary adjustment from March to dec not to change value in Jan, feb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks