Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=548118 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sales charts | Excel Discussion (Misc queries) | |||
Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
Calculate Total Sales from a Database | Excel Worksheet Functions | |||
Complex Sales Tax | Excel Worksheet Functions |