Thread: Income Tax
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default Income Tax

"maria" wrote:
I am working on a worksheet to figure the calculations and
submit the accrued sales payment on a monthly basis.


So I assume you are retailer. Right?

Cell B2 has the sales amount of 53647.81, cell C2 has the
sales tax. Oklahoma has a sales tax of 3%-3.75%, what
type of formula would I use?


That is inconsistent with the information I find online. Oklahoma sales tax
varies between 4.5% and 10% based on the ZIP code of either the seller or the
purchaser, generally depending on where the product is received. See
http://www.oktax.onenet.net/pod/retven.htm .

No matter. If you are a retailer, your records should show the amount of
sales tax charged for each purchase. The amount in C2 is the sum of those
sales tax amount, something like:

=SUM(X1:X100)

If this does not seem to answer your questions, please explain your
circumstances in more detail.