Thread: sales invoice
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default 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%, "")