Forum Discussion
Solved
Update prices based on list value
Hello, I would like to create a dynamic document that increases prices based on the year, the year being selected from a drop down list. I want to use this year as the starting point prices an...
On the other hand, if all you're saying is you want to be able to select an academic year and a single annual percentage rate to apply to each of the intervening years, then a simple FV (Future Value) function will do it. Here's a reference that explains the use of the function. I use it based on a single annual period, count the number of periods (years) based on the row the year occupies in your data validation table, and use the rate specified in the drop down box.
The formula reads like this:
=FV($F$3,MATCH($F$2,Sheet1!$A$1:$A$6,0),,Table1[@[Int Price (No VAT)]],0)*-1Minus 1 at the end just to turn the number into a positive.
