LinkBack URL
About LinkBacks
Pl find attached excel sheet.
Whenever i enter over the allowable limit, the tax should be shown in b1.
But it is shown as blank, Please kindly give the solution as it is a one cell formula to calculate tax
Pl find attached excel sheet.
Whenever i enter over the allowable limit, the tax should be shown in b1.
But it is shown as blank, Please kindly give the solution as it is a one cell formula to calculate tax
what exactly are you trying to do there?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi, I want to use this function to have the tax calculated at b1. If i enter any thing more than 200000, there should be some entry, that is tax to be collected in b1. I know that this formula would work, but i could not decipher the error, as the check shows that a value has been wrongly used in the formula
no, I meant tell me exactly what you are trying to make it do
Hi, it is a progressive rate, for that i want to use this formula, to give the tax at one cell at one go, without deducting the second slab rate etc. I hope you understand
sorry, I dont. take me through it step-by-step please
What i have given in the table is the tax slab rate from 0 to maximum amount.
I found that a simple formula exist for calculating this tax, by using sumproduct function for progressive rate of taxes. for example, if the amount is more than 200000 but less than 500000, then the tax rate 10%, but if the amount is more than 5 lakhs but less than 100000, the tax is to be worked out for by taking in to calculation, that upto 5 lakhs, the tax is 10 and over it only attracts 20%.I calculated the difference in the rate in the last part of sumproduct formula
Hi,
I found out the solution. It was not blank actually, but somebody in my computer has made font colour automatic to no colour. so, the result was there and not shown. I found this after some time, with clicking the fx button, there it shows the correct result, but not in the cell. There was no error messages shown. Then i changed the cell fill colour to black and found the answers shown. Then i realised that because of no colour font, the cell does not show the result and the result, i expected is correct. I am enclosing the same.
Last edited by rajuj; 02-08-2014 at 07:44 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks