View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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.