Question about tax formula

[paul79]

thanks for the fast response, i have another question that is a little harder. its has to do with tax

say the cell "tax" is on (a1) and the cell "price" is on (a2) and "total" is on (a3)
and "tax total" on (b1)

what i wan't is to be able to put in under "tax"(a1) a percentage...say for example 7.25% and then on the "price" i put in $100.00
i would like the "total" to say only 100.00 dollars but on the "tax total"(b1) to say $7.25 (the amount of tax).

 

[Ian Mac]

On 2002-09-06 16:52, paul79 wrote:
thanks for the fast response, i have another question that is a little harder. its has to do with tax

say the cell "tax" is on (a1) and the cell "price" is on (a2) and "total" is on (a3)
and "tax total" on (b1)

what i wan't is to be able to put in under "tax"(a1) a percentage...say for example 7.25% and then on the "price" i put in $100.00
i would like the "total" to say only 100.00 dollars but on the "tax total"(b1) to say $7.25 (the amount of tax).

If you just need the tax paid then:

=A2*A1

should work for your senario.

 

[paul79]

actually that is just for a single entry. what if i had like 20 then that wouldn't work maybe this diagram will help

A B C
1 "TAX" "PRICE" "TOTAL"
2 "TAX" "PRICE" "TOTAL"
3 "TAX" "PRICE" "TOTAL"
4 "TAX" "PRICE" "TOTAL"
5 "TAX" "PRICE" "TOTAL"

WITH THE INFO IN IT WOULD LOOK LIKE THE FOLLOWING

A B C
1 "7.25%" "$100.00" "$100.00"
2 "7.25% "$10.00" "$10.00"
3 "5% "$50.00" "$50.00"

THEN ON THE OTHER CELL CALLED "TOTAL TAX"
IT WOULD HAVE TO TOTAL AMOUNT PAID IN TAXES

D
10 $9.79

WHICH (D10) IS "TOTAL TAX"

PLEASE DISREGARED THE PREVIOUS EXPLANATION ON THE LOCATION OF THE CELLS. THNKS

 

[Ian Mac]

Hello,

Not sure why you even need Column C as it's the sam as B??

But for total tax:

Book1
	A	B	C	D
1	Tax	Price	Total
2	13.10%	868.00	868.00
3	15.00%	439.00	439.00
4	9.50%	549.00	549.00
5	12.60%	811.00	811.00
6	11.20%	227.00	227.00
7	7.80%	560.00	560.00
8	12.50%	212.00	212.00
9	12.50%	695.00	695.00	TotalTax
10	14.50%	169.00	169.00	540.88
Sheet1

hope this helps,