How do i get the sales tax to pop up???

Closed
mgamble1990 Posts 2 Registration date Monday March 21, 2016 Status Member Last seen March 22, 2016 - Mar 22, 2016 at 10:18 AM
Coley925 Posts 10 Registration date Tuesday March 22, 2016 Status Member Last seen March 31, 2016 - Mar 22, 2016 at 10:38 AM
Hello, how do I make it so I cant type in a city and have it so the sales tax automatically inserts itself in? Thank you



1 reply

Coley925 Posts 10 Registration date Tuesday March 22, 2016 Status Member Last seen March 31, 2016
Mar 22, 2016 at 10:38 AM
It would depend on exactly what you want.

Here is what I would do so that you have all of the information visible

Create another sheet that lists all of the cities and their specific tax rate.

Go back to sheet1, and insert a column beside your city and apply a Vlookup to search on sheet2, and then show the specific tax rate to be applied. then, where ever you need your final total to be, apply a formula using that specific tax rate.
0