Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating row by row | New Users to Excel | |||
Calculating % when 0 is 100% | Excel Worksheet Functions | |||
Calculating Age | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
calculating an age | Excel Discussion (Misc queries) |