|Forum Topic||Post Reply Login|
Calculating Total Sales Tax For Orders
Rate this:(3/5 from 1 vote)
|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.
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|
|There are currently no replies to the "Calculating Total Sales Tax for Orders" topic of the Excel Help Forum for Excel Invoice Template.|
|Find relevant Excel templates and add-ins for Calculating Total Sales Tax for Orders in the Excel Business Solutions Directory|