how to count one formula for counting tax
- Thread starter arif
- Start date
this was what i was doing until now sir but i want one formula only that will put both count tax in one cell and the other
like if this cell has 5% then amount against it should be summed up and put it in concerned cell and if the cell has 15% then sum of amounts against it should be summed up and tax based on that should be put in another cell
i want only one formula sir
thanks
like if this cell has 5% then amount against it should be summed up and put it in concerned cell and if the cell has 15% then sum of amounts against it should be summed up and tax based on that should be put in another cell
i want only one formula sir
thanks
Hi Arif,
I think you'll need to redo your sample. Original file said to create a formula in E33 and E34. First, there's nothing in those cells, so I assumed you wanted E18 and E19, as they were previously blank. Which cell(s) do you want the formula in, and what should be the expected result?
I think you'll need to redo your sample. Original file said to create a formula in E33 and E34. First, there's nothing in those cells, so I assumed you wanted E18 and E19, as they were previously blank. Which cell(s) do you want the formula in, and what should be the expected result?
This looks like the exact same file, you didn't update anything. 
How do you want just 1 formula but keep saying 2 cells? Which is it, 1 or 2??
It doesn't look like you've calculated any tax.
the first solution I posted put the respective tax in for each category in cells E18 and E19. What specifically about the solution was incorrect?
Please try again, this time providing a clear explanation of what you want. The more information you provide, the better chance we have at providing a solution.
Please answer all of the above questions.
How do you want just 1 formula but keep saying 2 cells? Which is it, 1 or 2??
It doesn't look like you've calculated any tax.
the first solution I posted put the respective tax in for each category in cells E18 and E19. What specifically about the solution was incorrect?
Please try again, this time providing a clear explanation of what you want. The more information you provide, the better chance we have at providing a solution.
Please answer all of the above questions.
David Evans
Active Member
sir in both cells there must be same formula in E18 5% tax will be put and in E17 15% tax should be put with the same formula
plz
update
plz
find updated file that i m attaching nowThis looks like the exact same file, you didn't update anything.
How do you want just 1 formula but keep saying 2 cells? Which is it, 1 or 2??
It doesn't look like you've calculated any tax.
the first solution I posted put the respective tax in for each category in cells E18 and E19. What specifically about the solution was incorrect?
Please try again, this time providing a clear explanation of what you want. The more information you provide, the better chance we have at providing a solution.
Please answer all of the above questions.
update
Seriously? This is again the EXACT same file. 
How do you want to calculate 2 different things with the same formula??
Also, your col D is inconsistent. Row 3 and 5 have a percentage in them, the other rows have regular numbers. No matter how you proceed, you will want to fix the data to be more consistent.
How do you want to calculate 2 different things with the same formula??
Also, your col D is inconsistent. Row 3 and 5 have a percentage in them, the other rows have regular numbers. No matter how you proceed, you will want to fix the data to be more consistent.
