#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Sales Taxes


In a workbook I have worksheets for each vendor that I buy from for my
business. Column A=product count...Column B=product cost....Column
C=product name/ID. Columns D and on are for each day of the year.
I have a problem in that different items that I buy are billed to me at
different Sales Tax rates. My question is this:
Is there a way that I can program any row on the worksheet to be
figured at a particular sales tax rate? GA has a state s/tax + our
county also has local option s/taxes. Some items are state exempt, some
aren't. Near the top of each column just below the date, I have a row
for subtotal of expenses in given that column, a state s/tax row and a
local option sales/tax row. I'd like for my cells/row that represents
the state s/t to automatically know whether a row/cell is to be taxed
or exempt.


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=568396

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default Sales Taxes

It would appear you need a table of Products and Tax rates:

Product Column A
State Tax Column B
Local tax Column C

And then use VLOOKUP to determine tax rate(%)/amount. If no tax applies,
you could set value to zero. And are the tax rates fixed or can they change
(maybe infrequently) but then they become date-dependent.

HTH


"lsmft" wrote:


In a workbook I have worksheets for each vendor that I buy from for my
business. Column A=product count...Column B=product cost....Column
C=product name/ID. Columns D and on are for each day of the year.
I have a problem in that different items that I buy are billed to me at
different Sales Tax rates. My question is this:
Is there a way that I can program any row on the worksheet to be
figured at a particular sales tax rate? GA has a state s/tax + our
county also has local option s/taxes. Some items are state exempt, some
aren't. Near the top of each column just below the date, I have a row
for subtotal of expenses in given that column, a state s/tax row and a
local option sales/tax row. I'd like for my cells/row that represents
the state s/t to automatically know whether a row/cell is to be taxed
or exempt.


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=568396


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Sales Taxes


Thank you for your reply.
I have inserted two columns, one for 4% and the other for 2% sales
taxes. I have no clue as to what I must do for "V-Lookup". Can you help
a little farther on this?
Thank you for your help.


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=568396

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sales Taxes lsmft Excel Discussion (Misc queries) 3 June 3rd 06 05:35 PM
Pivot table for reporting sales performance Ram Excel Discussion (Misc queries) 2 February 6th 06 10:06 AM
Calculate Total Sales from a Database John Excel Worksheet Functions 0 November 3rd 05 12:26 PM
Complex Sales Tax Robert Excel Worksheet Functions 8 January 12th 05 07:47 PM


All times are GMT +1. The time now is 12:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"