Forum Discussion

Mayemariel's avatar
Mayemariel
Copper Contributor
Aug 08, 2023

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...
  • mathetes's avatar
    Aug 08, 2023

    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. 

Resources