# MD_RST_6% ( Taxable ; Exempt )

Maryland State 6% Retail Sales Tax

Average rating: 4.6 (13 votes) Log in to vote

Jeep Watson Jeep Watson www |

MD_RST_6% ( 6.34 ; 0 )

MD_RST_6% ( 6.34 ; 1 )

.39

.00

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

Effective January 3, 2008, the Maryland sales and use tax rate is 6 percent, as follows (Note: The breaks are different for sales under $1 and over $1):

1 cent on each sale where the taxable price is 20 cents.

2 cents if the taxable price is at least 21 cents but less than 34 cents.

3 cents if the taxable price is at least 34 cents but less than 51 cents.

4 cents if the taxable price is at least 51 cents but less that 67 cents.

5 cents if the taxable price is at least 67 cents but less than 84 cents.

6 cents if the taxable price is at least 84 cents.

On each sale where the taxable price exceeds $1.00, the tax is 6 cents on each exact dollar, plus:

1 cent if the excess over an exact dollar is at least 1 cent but less than 17 cents.

2 cents if the excess over an exact dollar is at least 17 cents but less than 34 cents.

3 cents if the excess over an exact dollar is at least 34 cents but less than 51 cents.

4 cents if the excess over an exact dollar is at least 51 cents but less than 67 cents.

5 cents if the excess over an exact dollar is at least 67 cents but less than 84 cents.

6 cents if the excess over an exact dollar is at least 84 cents.

## Comments

comment, VR Aug 6, 2016 |
||

I believe you could do simply: Case ( Exempt or Amount < .2 ; 0 ; Amount = .2 ; .01 ; Ceiling ( 100 * Amount * .06 ) / 100 ) |
||

comment, VR Aug 6, 2016 |
||

Note that this assumes Amount is already rounded to whole cents. The regulations that you cite make the same assumption (otherwise there would be no tax on an amount of $0.209). | ||

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