I have created a dropdown of percentages. The list is cells A1:A3 and the dropdown is cell B5.
I want the selection in B5 to change if the user selects a city in cell B6
Example:
- User selects 0% in B5
- User selects Chicago (-10%) in B6
Output: -10% (0%-10%=-10%)
What I have tried: I wrote the following in cell B5 =IF($B$5=”Chicago”,”0%-10%”)
I will have different price decreases for each city. I am unsure how to use this formula when there is a dropdown.