Cash flow by date with annual increases

See attached copy.
Formula is in C7, copy down and across.

I tried to paste the formula here but my system won't allow it, sorry.

This does not look at lease expiration yet. It will keep increasing rent every 12 months forever.
If it works, let me know and we can add one more IF condition to stop when lease expires.

See attached copy.
Formula is in C7, copy down and across.
This takes care of lease expiration.

I tried to paste the formula here but my system won't allow it, sorry.

@modytrane

I tried to paste the formula here but my system won't allow it, sorry

When pasting a formula with a " <" or " >" always leave a space before it otherwise the system thinks it's HTML and probably dangerous

When pasting a formula with a " <" or " >" always leave a space before it otherwise the system thinks it's HTML and probably dangerous
Do you mean a space before each ">" and "<" or before the whole formula?
I tried both but it still doesn't work.


I tried but it gives me an error message.

Access Denied - Sucuri Website Firewall

If you are the site owner (or you manage this site), please whitelist your IP or if you think this block is an error please open a support ticket and make sure to include the block details (displayed in the box below), so we can assist you in troubleshooting the issue.

Block details:

Your IP: 4.15.24.122
URL: http://www.excelforum.com/newreply.p...eply&t=1303239
Your Browser: Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko
Block ID: BLKUNF1
Block reason: Your request was not authorized due to its content (HTML code not allowed).

=IF(OR(C$5 "less than" Inputs!$C8,C$5 "greater than" Inputs!$E8),"",IF(C$5=Inputs!$C8,Inputs!$B8*Inputs!$F8,IF(C$5 "greater than" Inputs!$C8,(1+Inputs!$H8)^(INT((C$5-Inputs!$C8)/360))*Inputs!$B8*Inputs!$F8)))

it works if I replace "<" and ">" with words as above.

@modytrane, I have found Sucuri will ignore the > altogether and will ignore the < if it is followed by a space as in the case of:
=IF(OR(C$5< Inputs!$C8,C$5>Inputs!$E8),"",IF(C$5=Inputs!$C8,Inputs!$B8*Inputs!$F8,IF(C$5>Inputs!$C8,(1+Inputs!$H8)^(INT((C$5-Inputs!$C8)/360))*Inputs!$B8*Inputs!$F8)))
By the way, Nice formula!