L
Legacy 327601
Guest
Hi,
I have a loan on a property that expires in 7 years. I want to model the property's sale in year 7 or earlier but not after year 7. I am trying to think of a formula that looks up what year the cash flow is in and what year the holding period is and if the cash flow year matches the holding period and it is not greater than year 7 will pull the net proceeds amount. however, if the hold period is greater than 7 years i want the column that corresponds to year 7 to show the net proceeds amount.
This is what i have so far:
IF(AND("Cash Flow Year"="Hold Period","Cash Flow Year"<"Year 7"),"Net Proceeds",0)
Please let me know if you need clarification or have questions.
Thank you for your help.
I have a loan on a property that expires in 7 years. I want to model the property's sale in year 7 or earlier but not after year 7. I am trying to think of a formula that looks up what year the cash flow is in and what year the holding period is and if the cash flow year matches the holding period and it is not greater than year 7 will pull the net proceeds amount. however, if the hold period is greater than 7 years i want the column that corresponds to year 7 to show the net proceeds amount.
This is what i have so far:
IF(AND("Cash Flow Year"="Hold Period","Cash Flow Year"<"Year 7"),"Net Proceeds",0)
Please let me know if you need clarification or have questions.
Thank you for your help.