Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
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.


Reply
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
Calculate Sales Amount lucrezia Excel Discussion (Misc queries) 3 October 6th 06 08:22 PM
Calculating total amount of sales for each salesman Exedate Excel Worksheet Functions 4 May 27th 05 09:53 PM
once you have an amount in a cell how do you get that amount to i. jillingore New Users to Excel 4 April 21st 05 01:42 PM
How do I calculate Amount of Sales Tax from Total Amount? MikeS Excel Worksheet Functions 1 March 26th 05 07:49 PM
I want to add 6% sales tax to the amount in a cell/column Bobb1220 Excel Discussion (Misc queries) 3 March 12th 05 01:58 PM


All times are GMT +1. The time now is 02:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"