Increase with condition

[Nitin gupta]

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]

=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