#### paul79

##### New Member
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).

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
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

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

Hello,

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

But for total tax:
Book1
ABCD
1TaxPriceTotal
213.10%868.00868.00
315.00%439.00439.00
49.50%549.00549.00
512.60%811.00811.00
611.20%227.00227.00
77.80%560.00560.00
812.50%212.00212.00
912.50%695.00695.00TotalTax
1014.50%169.00169.00540.88
Sheet1

hope this helps,

Replies
1
Views
136
Replies
3
Views
94
Replies
8
Views
191
Replies
3
Views
124
Replies
18
Views
10K

1,203,326
Messages
6,054,747
Members
444,748
Latest member
knowak87

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back