Forum Discussion
Drop-Down List + IF function
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.
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.
- You are welcome! Glad it worked for you.
- 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!
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.