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.