how do i set up sales tax?
 

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

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

"stephanie" wrote in message
...
Im trying to get the sales tax to calculate automatically rather than have
to
add it manually. any help is greatly appreciated.

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.



-----Original Message-----
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

"stephanie" wrote
in message
...
Im trying to get the sales tax to calculate
automatically rather than have
to
add it manually. any help is greatly appreciated.


.