Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
lsmft
 
Posts: n/a
Default Sales Taxes


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
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 charts brodiemac Excel Discussion (Misc queries) 3 March 3rd 06 05:30 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 02:55 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"