Hi Guys
I'm still relatively new to excel and wondering if anyone can help me out with (hopefully) a relatively simple formula.
I want to create a formula where I can escalate the rentals on an annual basis, but taking into account the differing dates when the leases where signed (would a "dated if" function be best for this?).
See attached Excel doc with red highlighted cells.
Thanks!
Bookmarks