I am trying to automate my monthly tax reports that tax me depending where in the state I am located. The state provides a "database" but it is just a map that I click on where the job was, so I can be taxed at that rate. It seems simple but complex. I have looked around for apps that do sales tax but they are usually enterprise level like SAP, so I don't need to go that route. I need to fill a field in with the tax rate for the particular county or municipality where I did the work, so that I can be taxed accordingly. Does anybody have any experience with switch statements with 60 different criteria in Excel?
builder7
0
Newbie Poster
AndreRet
526
Senior Poster
The syntax for the switch statement in excel (2019 up) is -
=SWITCH (expression, val1/result1, [val2/result2], ..., [default])I would thus suggest to create a column for all states, column for tax value and result should be then amount. Your expression would then look something like -
=SWITCH(A1,New York,"30%",Illenois,"20%",Texas,"10%","?")
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.