Drop-Down List + IF function

[Mayemariel]

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!

[#2 · Accepted solution]

@Mayemariel 

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. 

[#3]

This works, thank you so much!

[#4]

You are welcome! Glad it worked for you.

[#5]

Would it possible to add one entry that is free form? Like adding a city other than what's on the list and inserting whatever city tax % they have, if needed. Many thanks!

[#6]

@Mayemariel 

Would it possible to add one entry that is free form? Like adding a city other than what's on the list and inserting whatever city tax % they have, if needed. Many thanks!

It makes more sense to increase the table. Part of the idea of a table and the associated data validation aspect of the drop down is the greater assurance of data integrity. For the sake of a reliable spreadsheet, you don't want users to be able to make random entries.

See the attached.

[#7]

I agree, thank you for your continued assistance!