Assistance with Growth Increments

[Gregg Wolin]

The formula below effectively takes a "starting" rental rate (C5) and increases it at a specific rate (C7) one time annually on a specific month (C6).

=IF(MONTH(D$3)<>$C$6,C5,C5*(1+$C$7))

I tried tweaking the formula to allow for the addition of a start (C14) and end date (C18) during which the increases take place but the code below doesn't do it.

=IF(AND(D12>$C$14,D12<=$C$18),IF(MONTH(D$12)<>$C$16,C15,C15*(1+$C$17)),0)

 

[vletm]

Gregg Wolin
Could You try this?

 

[p45cal]

D13:

=IF(AND(D$12>$C$14,D$12<=$C$18,MONTH(D$12)=$C$16),C15*(1+$C$17),C15)

E13 copied across:

=IF(AND(E$12>$C$14,E$12<=$C$18,MONTH(E$12)=$C$16),D13*(1+$C$17),D13)

or

D13:

=C15*(1+IF(AND(D$12>$C$14,D$12<=$C$18,MONTH(D$12)=$C$16),$C$17,0))

E13 copied across:

=D13*(1+IF(AND(E$12>$C$14,E$12<=$C$18,MONTH(E$12)=$C$16),$C$17,0))

or

D13:

=C15*(1+AND(D$12>$C$14,D$12<=$C$18,MONTH(D$12)=$C$16)*$C$17)

E13 copied across:

=D13*(1+AND(E$12>$C$14,E$12<=$C$18,MONTH(E$12)=$C$16)*$C$17)

 

[Gregg Wolin]

D13:

=IF(AND(D$12>$C$14,D$12<=$C$18,MONTH(D$12)=$C$16),C15*(1+$C$17),C15)

E13 copied across:

=IF(AND(E$12>$C$14,E$12<=$C$18,MONTH(E$12)=$C$16),D13*(1+$C$17),D13)

or

D13:

=C15*(1+IF(AND(D$12>$C$14,D$12<=$C$18,MONTH(D$12)=$C$16),$C$17,0))

E13 copied across:

=D13*(1+IF(AND(E$12>$C$14,E$12<=$C$18,MONTH(E$12)=$C$16),$C$17,0))

or

D13:

=C15*(1+AND(D$12>$C$14,D$12<=$C$18,MONTH(D$12)=$C$16)*$C$17)

E13 copied across:

=D13*(1+AND(E$12>$C$14,E$12<=$C$18,MONTH(E$12)=$C$16)*$C$17)

Thank You!!!!