how do i set up sales tax?

S

stephanie

Im trying to get the sales tax to calculate automatically rather than have to
add it manually. any help is greatly appreciated.
 
P

Paul B

Stephanie, if the amount to tax is in A1 in another cell put =A1*tax rate,
so if the tax rate is 7% put =A1*0.07
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
F

FGM

Stephanie, if the amount to tax is in A1 in another cell
put =A1*tax rate,
so if the tax rate is 7% put =A1*0.07

In addition to person above comment. You could put the
tax rate in A1 then you can refer to that each place you
need to get the total. ex. summing orders C1-C9 in C10
put Sum(C1:C9)*$A$1. You can also give A1 a name like
TaxRate and then do * TaxRate.
 
Top