Calculating Total Sales Tax for Orders

Excel Help for Calculating Total Sales Tax For Orders in Excel Invoice Template

Calculating Total Sales Tax For Orders

Rate this: (3/5 from 2 votes)

	Several users have asked how a the total sales tax charged can be calculated and aggregated for multiple orders (invoices). This information isn't separated in the 'Reports' nor explicitly stored in the 'Orders' sheet; however it can be derived from the invoice information that is saved in the 'Orders' sheet. To calculate the Sales Tax attributable to the first order (saved invoice), the following formula must be entered into cell M2 of the 'Orders' sheet. =LEFT(K2,FIND("|",K2,1)-1)-RIGHT(K2,LEN(K2)-FIND("|",K2,1))-F2*(1-(H2/100))-OFFSET(shipmethods,J2-1,2,1,1) The formula can then be copied down to subsequent rows and then totaled in order to obtain an aggregate of the sales tax charged.
	Excel Business Forums Administrator
	Posted by Excel Helper on 18 Nov 2010

There are currently no replies to the "Calculating Total Sales Tax for Orders" topic of the Excel Help Forum for Excel Invoice Template. Post Reply