Hi there,
I'm fairly new to Excel - can you somehow put formulas in a drop down list?
I'm trying to give the option of either averaging a value over 12months or just one month (with the option of choosing what month the value goes into) - image below.
Is this possible to do a drop down list, where the user can type in a value, and choose either a month or to average the value over 12 months?
Any help appreciated!
Screen Shot 2018-12-14 at 9.47.42 AM.png
Bookmarks