Jan 22 2022 02:37 PM
Did a good bit of searching before posting and cant seem to find anything; I have a special event business that is seasonal with high demand on weekends and trying to improve our way of charging for our good and services and by implementing "dynamic pricing".
we currently estimate event using a spread sheet and would like to just add in a couple cells that add to or discount based on a month or day drop down selection.
Cant figure out how to upload a file so here is a Link to a simple example with notes on what I am trying to acheive.
Just need to know how to:
1. get the two needed drop down selections for the cells
2. Associate a multiplier to those (Day/Month) values
3. Show the associated value for the selection
Thanks,
Michael
Jan 22 2022 03:01 PM
See the attached workbook.
Jan 22 2022 03:21 PM
Jan 22 2022 03:39 PM
Solution
Here's another way to do what Hans has suggested:
https://docs.google.com/spreadsheets/d/1O_mBs7R3bzziZ0AbJ-4hofWohlOee87G5ciArGwfdWY/edit?usp=sharing
You may be able to understand the logic a little more easily.
Cells B7 and B8 have been equipped with Data Validation to help prevent entry spelling errors.
David
Jan 22 2022 05:53 PM
@compassguy
This has got me real close, thankyou!
I will work with this and see how I can implement it into my actual spread sheet, thank you!
Jan 22 2022 10:08 PM
Jan 22 2022 03:39 PM
Solution
Here's another way to do what Hans has suggested:
https://docs.google.com/spreadsheets/d/1O_mBs7R3bzziZ0AbJ-4hofWohlOee87G5ciArGwfdWY/edit?usp=sharing
You may be able to understand the logic a little more easily.
Cells B7 and B8 have been equipped with Data Validation to help prevent entry spelling errors.
David