Forum Discussion
Solved
Drop-Down List + IF function
Is it possible to have a drop-down list of cities that once chosen, the sales tax use in % will populate in a separate cell and that cell will multiply to another cell (subtotal) to create a grand total based on the cities chosen on the drop-down list.
Many thanks!
Is it possible?
Yes. Just create a table of city names and associated taxes. Use the city name as the basis for the drop down. I've attached a simple example.
