IF(And()) Formula

[Legacy 327601]

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.

 

[konew1]

If you are wanting to compare results for several "Cash Flow Years" and "Hold Periods" you should consider creating a data table.
On the Data ribbon click icon for what-if analysis then take "data table" option
Read the xl help on it, and see if it is what you need.