Is there a formula that changes a multiplier based on the year?

[markcue]

I'm trying to figure out if I can have a single cell change the multiplier based on the year.
Example:

		A	B	C	D	E
1	YEAR	START	STOP	HOURS	MEAL (DOM)	MEAL (INT'L)
2	2014	6 AM	4 PM	10	22.00	26.50
3	2016	6 AM	4 PM	10	23.50	27.00

<tbody>
</tbody>

I'm multiplying C2 x the value of D2 and E2

D2 has a value of 2.20 (based on the year 2014). It goes up .05 every year till 2017

E2 has a value of 2.60 (based on the year of 2014). It goes up .05 ever year till 2017

If the year is 2014, the value of C2 (hours) multiplies the value of D2 (2.20 based on the year). If the year is 2016, the value of C2 (hours) multiplies the value of D2 (2.30 based on the year).

How can I make D2 or E2 reflect the multiplier based on what year it is?

 

[jbeaucaire]

I show the column references different than you:

  A	  B		  C		  D	  E	 	  F
YEAR	START		STOP		HOURS	MEAL (DOM)	MEAL (INT'L)
2014	6:00 AM		4:00 PM		10	22.00		26.00
2016	6:00 AM		4:00 PM		10	23.00		27.00

ANd based on your descriptions my results are different....

E2: =(2.2+(($A2-2014)*0.05))*$D2
F2: =(2.6+(($A2-2014)*0.05))*$D2

 

[bschwartz]

Since Year is not in an actual column, I'm assuming that you want this change with the actual date. So that when today's date becomes the year 2015 on January 1, the formulas should change. I am also assuming that after the year 2017, the the value of the multiplier remains steady at .15.

To be clear, I don't quite understand how you got the values of 26.50 or 23.50 in cells E2 and D3, so I might have misunderstood something. Please clarify if that's the case. Given the current value of C2, my formula will return 22 and 26 in 2014, 22.5 and 26.5 in 2015, 23 and 27 in 2016, and 23.5 and 27.5 from 2017 and on.

Excel 2010
	A	B	C	D	E
1	A	B	C	D	E
2	START	STOP	HOURS	MEAL (DOM)	MEAL (INT'L)
3	6:00 AM	4:00 PM	10	22	26
Sheet4

Cell Formulas
Range	Formula
D3	=C3*(2.2+MIN((YEAR(TODAY())-2014)*0.05,0.15))
E3	=C3*(2.6+MIN((YEAR(TODAY())-2014)*0.05,0.15))