ExcelBanter - increase number with 1%

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - increase number with 1% (https://www.excelbanter.com/excel-worksheet-functions/85303-increase-number-1%25.html)

Nitin gupta

increase number with 1%

Want to increase number by 1% each year for first 3 years and the thereafter
ther will be no increase for next 4 years

Stefi

increase number with 1%

I suppose you have somewhere the actual number of years. If so and I
understood you well

=A1*1.01^IF(B1<=3,B1,3)

where A1 contains the number to be increased
B1 contains the actual number of years

Regards,
Stefi

€žNitin gupta€ ezt Ã*rta:

Want to increase number by 1% each year for first 3 years and the thereafter
ther will be no increase for next 4 years

All times are GMT +1. The time now is 01:03 AM.