Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 48
Default Calculating Tax %

hi i have an order form that i want to calculate a tax of 5% on all orders,
meaning any ordered goods will have a 5% tax charge on them how do i do it.
thanks
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default Calculating Tax %

Hi,

Where A1 is the goods price

=A1*1.05

Mike

"Amin" wrote:

hi i have an order form that i want to calculate a tax of 5% on all orders,
meaning any ordered goods will have a 5% tax charge on them how do i do it.
thanks

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default Calculating Tax %

How you do it in your calculator?


"Amin" wrote:

hi i have an order form that i want to calculate a tax of 5% on all orders,
meaning any ordered goods will have a 5% tax charge on them how do i do it.
thanks

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,344
Default Calculating Tax %

Hi,

Mike's suggestion is best but think of it this way

5%*$200 = $10
total = 200+10
so you could write it
=A1+5%*A1 or =A1+0.05*A1

--
Thanks,
Shane Devenshire


"Amin" wrote:

hi i have an order form that i want to calculate a tax of 5% on all orders,
meaning any ordered goods will have a 5% tax charge on them how do i do it.
thanks

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
calculating row by row DARKMAN New Users to Excel 1 August 26th 08 03:31 AM
Calculating % when 0 is 100% Alison Excel Worksheet Functions 3 February 23rd 06 07:05 PM
Calculating Age malvis Excel Worksheet Functions 6 October 20th 05 01:21 PM
Calculating recurring date in following month, calculating # days in that period Walterius Excel Worksheet Functions 6 June 4th 05 11:21 PM
calculating an age rocket0612 Excel Discussion (Misc queries) 6 May 30th 05 11:35 AM


All times are GMT +1. The time now is 01:17 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"