Question about tax formula

paul79

New Member
Joined
Sep 5, 2002
Messages
3
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

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Ian Mac

MrExcel MVP
Joined
Feb 20, 2002
Messages
1,174
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

New Member
Joined
Sep 5, 2002
Messages
3
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
 

Watch MrExcel Video

Forum statistics

Threads
1,129,553
Messages
5,636,976
Members
416,953
Latest member
broexc

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top