# Add yearly % increase to lookup result

#### william11

##### New Member
Hi,

Every year each customers locker fees increases by 5%

I need this equation in cell N4:

to increase by 5% for every year that passes in cell J4 (date format 1/1/1900).

I hope this is possible, thank you.

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Code:
``=(EXISTING FORMULA)+0.05*(year(now())-year(J4))``

Code:
``=(EXISTING FORMULA)+0.05*(year(now())-year(J4))``

Thank you for the response.

The formula you provided adds 5 cents (.05) per year. I need the \$33.00 locker fee to increase by 5% for every year it has been leased.. exponentially.

=(LOOKUP(F5,Table3)+LOOKUP(G5,Table3[#All])+'Add a locker'!\$H5)+0.05*(YEAR(NOW())-YEAR(J5)) that what it looks like when I plug it in

year 1 = \$33 * .05 = \$1.65 + \$33 = \$34.65

year 2 = \$34.65 * .05 = \$1.73 + \$34.65 = \$36.38

year 3 = \$36.38 * .05

Then just change the formula slightly....

Code:
``=[FORMULA HERE]*(1+(5%*(YEAR(NOW())-YEAR(J4))))``

Then just change the formula slightly....

Code:
``=[FORMULA HERE]*(1+(5%*(YEAR(NOW())-YEAR(J4))))``

Thank you for you help, but your formula only works for year 1 because you are multiplying 5% by 1. Once you reach 2 years and beyond the formula will no calculate correctly. But thanks for the format, once I figure the correct math equation it will work perfectly. I think I need to add a Simplified Compound Interest equation.

Last edited:

Replies
5
Views
405
Replies
1
Views
523
Replies
4
Views
482
Replies
3
Views
517
Replies
7
Views
215

1,219,970
Messages
6,151,213
Members
451,017
Latest member
peterlam84

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back