IF Statement * Choose Formula Help

[jkjuliek]

=(Remaining Units*Renovated Rent)*12*(1+Yr1Growth)*IF(HoldPeriod>=2,1+Yr2Growth,1)*IF(AND(HoldPeriod>1,HoldPeriod<2),1+Yr2Growth/2,1)*IF(HoldPeriod>=3,1+Yr3Growth,1)*IF(HoldPeriod>=4,1+Yr4Growth,1)*IF(HoldPeriod>=5,1+Yr5Growth,1)*IF(HoldPeriod>=6,1+Yr6Growth,1)*IF(HoldPeriod>=7,1+Yr6Growth,1)*IF(HoldPeriod>=8,1+Yr6Growth,1)*IF(HoldPeriod>=9,1+Yr6Growth,1)*IF(HoldPeriod>=10,1+Yr6Growth,1)*(1+CHOOSE(HoldPeriod,Yr2Growth,Yr3Growth,Yr4Growth,Yr5Growth,Yr6Growth,Yr6Growth,Yr6Growth,Yr6Growth,Yr6Growth,Yr6Growth)/2)

[FDibbins]

Hi, welcome to the forum

It doesnt help anyone when you just post a formula like that.
What is your question?
what does it relate to?
what are you having a problem with?
where is teh sample data for members to "play" with?

Dont just expect everybody to understand what you have and know what you want