Hi Paul, I am afraid I don't understand. I want to take cash and credit
card sales and be able to figure out what we owe the Dept. of Revenue each
month. It is not a problem for us to tabulate this figure for ourselves; I
just figured that with excel there would be some formula I could put in for
it to do it automatically. Our tax rate is 7%. Thanks for any information
you may offer.

"Paul B" wrote:

Deanna, would total sale times sale tax rate work?

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

"Deanna" wrote in message
...
My husband and I just opened a business and I have created a chart on
excel
for us to track daily sales but also to figure sales tax so we know what
to
send the IRS each month. We have been figuring the sales tax ourselves
and
filling in the chart on excel but I would like to create a formula that
automatically does it for me based on total sales.