Forum Discussion
Mayemariel
Aug 08, 2023Copper Contributor
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 to...
- Aug 08, 2023
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.
mathetes
Aug 08, 2023Silver Contributor
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.
- MayemarielAug 10, 2023Copper ContributorThis works, thank you so much!
- mathetesAug 10, 2023Silver ContributorYou are welcome! Glad it worked for you.
- MayemarielAug 15, 2023Copper ContributorWould 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!