Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i set up sales tax?
Im trying to get the sales tax to calculate automatically rather than have to
add it manually. any help is greatly appreciated. |
#2
|
|||
|
|||
Stephanie, if the amount to tax is in A1 in another cell put =A1*tax rate,
so if the tax rate is 7% put =A1*0.07 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "stephanie" wrote in message ... Im trying to get the sales tax to calculate automatically rather than have to add it manually. any help is greatly appreciated. |
#3
|
|||
|
|||
Stephanie, if the amount to tax is in A1 in another cell put =A1*tax rate, so if the tax rate is 7% put =A1*0.07 In addition to person above comment. You could put the tax rate in A1 then you can refer to that each place you need to get the total. ex. summing orders C1-C9 in C10 put Sum(C1:C9)*$A$1. You can also give A1 a name like TaxRate and then do * TaxRate. -----Original Message----- Stephanie, if the amount to tax is in A1 in another cell put =A1*tax rate, so if the tax rate is 7% put =A1*0.07 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "stephanie" wrote in message ... Im trying to get the sales tax to calculate automatically rather than have to add it manually. any help is greatly appreciated. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with sales chart | Charts and Charting in Excel | |||
tracking sales to targets in a chart | Charts and Charting in Excel | |||
is there a template for an electronic charge sales slip? | Excel Discussion (Misc queries) | |||
Looking for a temlate for sales and commission input? | Excel Discussion (Misc queries) | |||
conditional formating - Highlighting text cells based on sales res | Excel Discussion (Misc queries) |