Sales Taxes

Giganews Newsgroups
Subject: Sales Taxes
Posted by:  lsmft (lsmft.28u0zb_1149348001.3662@excelforum-nospam.com)
Date: Sat, 3 Jun 2006

Started a new worksheet listing all purchased items by name in column
A.
Column B will list how much was spent for each item.
Problem arises when some of the items are taxed at 2 %, some at 3 %,
some at 4%, and some at 6 %.
My question:
Is there a way to denote how much or what rate an item will be taxed
at?
For example:
Row 10, colum B is a grocery food item, hence not state tax, just the
local option taxes.
Row 11, colum B is a cleaning supply item, and will be taxed at the
state S/Tx rate.
I would like to be able to program the whole row for whatever the tax
rate would be. Can this be done?

--
lsmft
------------------------------------------------------------------------
lsmft's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=30678
View this thread:http://www.excelforum.com/showthread.php?threadid=548118

Replies