ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sales tax total amount from one cell amount to another cell (https://www.excelbanter.com/excel-discussion-misc-queries/143322-sales-tax-total-amount-one-cell-amount-another-cell.html)

ROSIEMSM

sales tax total amount from one cell amount to another cell
 
I WANT TO GET THE FORMULA IF THERE IS ONE ON HOW TO GET THE TOTAL SALES TAX
ON MY HOME MADE INVOICES FROM AN AMOUNT ON ONE OF THE CELLS TO ANOTHER CELL.

Don Guillett

sales tax total amount from one cell amount to another cell
 
First, typing in all CAPS is considered shouting and rude unless one word
for emphasis.
where a2:a22 is the item list and sales tax is in cell a1
=sum(a2:a22)*a1
--
Don Guillett
SalesAid Software

"ROSIEMSM" wrote in message
...
I WANT TO GET THE FORMULA IF THERE IS ONE ON HOW TO GET THE TOTAL SALES TAX
ON MY HOME MADE INVOICES FROM AN AMOUNT ON ONE OF THE CELLS TO ANOTHER
CELL.




All times are GMT +1. The time now is 02:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com