stateSalesTaxRate ( state )

Outputs the tax rate for state that was passed.

Average rating: 4.1 (39 votes) Log in to vote

Jason P. Scharf - Show more from this author

Sample input:

stateSalesTaxRate ( "IN" )

Sample output:

.07

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/********************************************************
 stateSalesTaxRate ( state )
 
 Version 1.0.3 [2/3/2011 9:12:24 PM]
 ---------------------------------------------
 Jason P. Scharf
 jscharf@dbservices.com
 www.dbervices.com
 ---------------------------------------------
 
 Returns the tax rate for the supplied state. If an
 invalid value is provided the function will return an
 empty result.
 
 ********************************************************/
 
 Case (

	state = "Alabama" or state = "Ala." or state = "AL" ;
		.04;

	state = "Alaska" or state = "Alaska" or state = "AK" ;
		0;

	state = "Arizona" or state = "Ariz." or state = "AZ" ;
		.056;

	state = "Arkansas" or state = "Ark." or state = "AR" ;
		.06;

	state = "California" or state = "Calif." or state = "CA" ;
		.0825;

	state = "Colorado" or state = "Colo." or state = "CO" ;
		.029;

	state = "Connecticut" or state = "Conn." or state = "CT" ;
		.06;

	state = "Delaware" or state = "Del." or state = "DE" ;
		0;

	state = "District of Columbia" or state = "D.C." or state = "DC" ;
		.04;

	state = "Florida" or state = "Fla." or state = "FL" ;
		.06;

	state = "Georgia" or state = "Ga." or state = "GA" ;
		.04;

	state = "Hawaii" or state = "Hawaii" or state = "HI" ;
		.04;

	state = "Idaho" or state = "Idaho" or state = "ID" ;
		.06;

	state = "Illinois" or state = "Ill." or state = "IL" ;
		.0625;

	state = "Indiana" or state = "Ind." or state = "IN" ;
		.07;

	state = "Iowa" or state = "Iowa" or state = "IA" ;
		.06;

	state = "Kansas" or state = "Kans." or state = "KS" ;
		.053;

	state = "Kentucky" or state = "Ky." or state = "KY" ;
		.06;

	state = "Louisiana" or state = "La." or state = "LA" ;
		.04;

	state = "Maine" or state = "Maine" or state = "ME" ;
		.05;

	state = "Maryland" or state = "Md." or state = "MD" ;
		.06;

	state = "Massachusetts" or state = "Mass." or state = "MA" ;
		.0625;

	state = "Michigan" or state = "Mich." or state = "MI" ;
		.06;

	state = "Minnesota" or state = "Minn." or state = "MN" ;
		.06875;

	state = "Mississippi" or state = "Miss." or state = "MS" ;
		.07;

	state = "Missouri" or state = "Mo." or state = "MO" ;
		.04225;

	state = "Montana" or state = "Mont." or state = "MT" ;
		0;

	state = "Nebraska" or state = "Nebr." or state = "NE" ;
		.055;

	state = "Nevada" or state = "Nev." or state = "NV" ;
		.0685;

	state = "New Hampshire" or state = "N.H." or state = "NH" ;
		0;

	state = "New Jersey" or state = "N.J." or state = "NJ" ;
		.07;

	state = "New Mexico" or state = "N.M." or state = "NM" ;
		.05;

	state = "New York" or state = "N.Y." or state = "NY" ;
		.04;

	state = "North Carolina" or state = "N.C." or state = "NC" ;
		.0575;

	state = "North Dakota" or state = "N.D." or state = "ND" ;
		.05;

	state = "Ohio" or state = "Ohio" or state = "OH" ;
		.055;

	state = "Oklahoma" or state = "Okla." or state = "OK" ;
		.045;

	state = "Oregon" or state = "Ore." or state = "OR" ;
		0;

	state = "Pennsylvania" or state = "Pa." or state = "PA" ;
		.06;

	state = "Rhode Island" or state = "R.I." or state = "RI" ;
		.07;

	state = "South Carolina" or state = "S.C." or state = "SC" ;
		.06;

	state = "South Dakota" or state = "S.D." or state = "SD" ;
		.04;

	state = "Tennessee" or state = "Tenn." or state = "TN" ;
		.07;

	state = "Texas" or state = "Tex." or state = "TX" ;
		.0625;

	state = "Utah" or state = "Utah" or state = "UT" ;
		.047;

	state = "Vermont" or state = "Vt." or state = "VT" ;
		.06;

	state = "Virginia" or state = "Va." or state = "VA" ;
		.05;

	state = "Washington" or state = "Wash." or state = "WA" ;
		.065;

	state = "West Virginia" or state = "W.Va." or state = "WV" ;
		.06;

	state = "Wisconsin" or state = "Wis." or state = "WI" ;
		.06;

	state = "Wyoming" or state = "Wyo." or state = "WY" ;
		.05;

	//INVALID VALUE PROVIDED
 		""
 )

This function will provide the state sales tax rate for all 50 states, and D.C.

You can provide a state in one for three formats: full name, standard abbreviation, and postal abbreviation (e.g., Indiana, Ind., IN).

Comments

		Bruce Robertson Feb 3, 2011
WA state tax is address-specific, see: http://dor.wa.gov/Content/FindTaxesAndRates/RetailSalesTax/DestinationBased/ClientInterface.aspx

		Andy Frazier, Mx4Px Feb 4, 2011
State rates are a good start...but check out NY rates, which have multiple rates per city. Or TN - they have rates which vary by county and purchase amount. Sales tax is a bit of a rabbit hole issue no matter how you slice it. Unless you live in NH ;-)

		Bert, Los Angeles, CA Feb 8, 2011
CA has a base tax rate that is then increased based on the county/city/district rate. Even within a County we can have more than one final rate.

		Jason Scharf, Sellersburg, IN Feb 10, 2011
I have to agree that the fucntion falls short! Does anyone have a good idea on how best to account for the tax codes of states like OH, CA, and NY?

		Sean, Private Mar 3, 2011
This should not be a function, but rather a table and have a lookup copy the tax data over.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

stateSalesTaxRate ( state )

Comments

Support this website.

Support this website.