ExcelBanter - Increase with condition

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

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

- - Increase with condition (https://www.excelbanter.com/excel-worksheet-functions/85302-increase-condition.html)

Nitin gupta

Increase with condition

Want to increase Interest rate of 10% by 1% every year till it reaches 15%
and therafter it remains constant over a period of 10 years

Stefi

Increase with condition

=IF(A1+0.01*B1<=0.15,A1+0.01*B1,0.15)

where A1 contains the original Interest rate of 10%
B1 contains the actual number of years

Regards,
Stefi

€žNitin gupta€ ezt Ã*rta:

Want to increase Interest rate of 10% by 1% every year till it reaches 15%
and therafter it remains constant over a period of 10 years

All times are GMT +1. The time now is 06:57 PM.