L
lsmft
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.
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.