Could you attach the file with the error? That would be helpful to troubleshoot this. Be sure to check the ‘Set as private reply’ box when you attach the file if you want to protect the confidentiality of the deal you’re modeling.
In terms of what might be the issue. One possibility is that there’s an actual bug – if so, once I see the file I’ll be sure to include a fix in an upcoming version. If it’s not a bug, than it’s an input error. I see a couple common input errors on the rent roll that you should look out for:
1) Be sure no cells are left blank. So if you select 11 tenants, be sure you’ve completed each cell in each row for each tenant.
2) Be sure you’ve entered values without words where inputs include in-cell labels. So for instance, column BK (Downtime) includes in-cell labels “X months”. The user enters 9, and the cell outputs “9 months” but Excel still treats the value as the number 9. However, if the user enters “9 months”, Excel does not recognize the input as a number but rather as text and can’t use the value in subsequent formulas.
