Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sales invoice
I am using the sales invoice template and I am trying to customize of
course. What I want to do is have the tax rate (5.5%) automatically put in if the state that the order is coming from is WI. Can't quite figure out how to do the formula/function Any help would be appreciated, Thanks, Al |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sales invoice
Al wrote:
I am using the sales invoice template and I am trying to customize of course. What I want to do is have the tax rate (5.5%) automatically put in if the state that the order is coming from is WI. Can't quite figure out how to do the formula/function Maybe something like this.... If A1 constains the state (WI), try: =if(A1="WI", 5.5%, "") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sales invoice
Al
Assuming the Invoice.xlt is the one with Excel 2002 or 2003..... =IF(F15="WI",0.055,"") entered in L38 or L39 Gord Dibben MS Excel MVP On Fri, 19 Jan 2007 05:47:36 GMT, "Al" wrote: I am using the sales invoice template and I am trying to customize of course. What I want to do is have the tax rate (5.5%) automatically put in if the state that the order is coming from is WI. Can't quite figure out how to do the formula/function Any help would be appreciated, Thanks, Al |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sales invoice
Gawd do I feel stupid!
Thanks for the quick and easy answer "Al" wrote in message ... I am using the sales invoice template and I am trying to customize of course. What I want to do is have the tax rate (5.5%) automatically put in if the state that the order is coming from is WI. Can't quite figure out how to do the formula/function Any help would be appreciated, Thanks, Al |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
figuring commissions based on gross sales | Excel Worksheet Functions | |||
I am making a sales invoice but I can't change $ to £ sign | Excel Discussion (Misc queries) | |||
How do I modify the sales invoice template? | Excel Discussion (Misc queries) | |||
Master invoice number | Excel Worksheet Functions | |||
assign number to sales invoice | Excel Worksheet Functions |