Hi Everyone,
I've been trying to work through this but I can't figure it out.
Basically I'm working with a formula whereby C44 can't be a negative number. C43 is a number that I want to maximize up to a certain allowable amount which is calculated elsewhere. Say the maximum value C43 can be is 10,000 but that gives a -2,000 value in C44. I want it to automatically be 8,000 when C44 is a negative, but 10,000 if that gives a positive or 0 value.
C40: NOI
C41: less Leasing Costs
C42: less Interest
C43: less CCA
= C44 (Must be a positive value)
In cell C50 I calculate the Maximum CCA. I want as much of this as possible. I use the maximum if C44 is greater than or =0 when inserted, or as much as possibly so it = 0.
As you can tell I can barely explain it well enough, probably why I can't figure this out :p
Bookmarks