Multi-State Sales Tax Computation

C

CraigR53

We sell products to about 20 states. I need to compute the sales tax for each
sale based on the state in which it is sold. I propose to set up a table --
Col A is 2-letter abreviation for state (eg, "MN") & col 2 is Tax Rate
(eg,".065"). I then want the user to enter the state abreviation in, for
example, D4, and have the correct rate appear in E4. How can I do this?
(I'm a git of a beginner -- try to dumb down your answer for me, if you can.)

Thanks!!

Craig
 
C

Chip Pearson

Use the VLOOKUP function. For example,

=VLOOKUP(state_name,$A$1:$B$21,2,FALSE)

where state_name is the state to lookup (either literal text in
quotes or a cell reference, and A1:B21 is your list of states and
respective tax rates.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
C

CraigR53

Perfect, Chip! Thanks muchly!!!

Craig

Chip Pearson said:
Use the VLOOKUP function. For example,

=VLOOKUP(state_name,$A$1:$B$21,2,FALSE)

where state_name is the state to lookup (either literal text in
quotes or a cell reference, and A1:B21 is your list of states and
respective tax rates.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sales Taxes 2
Tax Computation 1
tax computation in Access query 3
creating a table for accessing data via Access forms 5
handle different sales tax rates for same item based on location. 1
Invoices with Sales Order & Purchase Order 1
Computing totals for tax and non-tax items 2
Normalizing Monthly Sales Data 5

Top