No error or suggestion; more of a query as to programming style. Why do you use the IF function when linking text from one worksheet to another? The example I see in your model is:
=IF(‘ORI-RR’!$B12=””,””,’ORI-RR’!B12)
which links the tenant number between ORI-RR and ORI-Calc.
I assumed the purpose of the formula is to keep a #DIV error {divide by 0} from showing in the rows which have not yet been filled in yet – which is a good programming practice to trap errors like #DIV error.
I use the IF (CELL=””, then X, otherwise Y) concept in this model to make the model Dynamic to the hold period.
The header is built such that if a specific period is beyond the hold period, then the cell is left empty (i.e “”). Then, each formula first asks whether the period is empty (I.e. beyond the hold period), if so leave the cell empty, otherwise show the Cash flow.
