Im getting the error "The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format." How do I make this work without changing file format?
=IF(S4>0.15,CONCATENATE(B4&" "&D4&"|"&"Rate of Return ="&T4&"/ "&"MLS ID= "&A4&"/ Row "&ROW()&"/ "&$G4&"/"&H4&" Assumed Cashflow of $"&R4&"/month|blue|15%+ ROR"),IF(S4>0.10,CONCATENATE(B4&" "&D4&"|"&"Rate of Return ="&T4&"/ "&"MLS ID= "&A4&"/ Row "&ROW()&"/ "&$G4&"/"&H4&" Assumed Cashflow of $"&R4&"/month|smallgreen|10%+ ROR"),IF(S4>0.05,CONCATENATE(B4&" "&D4&"|"&"Rate of Return ="&T4&"/ "&"MLS ID= "&A4&"/ Row "&ROW()&"/ "&$G4&"/"&H4&" Assumed Cashflow of $"&R4&"/month|smallgreen|"),IF(S4>0,CONCATENATE(B4&" "&D4&"|"&"Rate of Return ="&T4&"/ "&"MLS ID= "&A4&"/ Row "&ROW()&"/ "&$G4&"/"&H4&" Assumed Cashflow of $"&R4&"/month|smallgreen|0%+ ROR"),IF(S4<0,CONCATENATE(B4&" "&D4&"|"&"Rate of Return ="&T4&"/ "&"MLS ID= "&A4&"/ Row "&ROW()&"/ "&G4&"/"&H4&" Assumed Cashflow of $"&R4&"/month|smallred| Negative ROR <5%", IF(S4<0,CONCATENATE(B4&" "&D4&"|"&"Rate of Return ="&T4&"/ "&"MLS ID= "&A4&"/ Row "&ROW()&"/ "&G4&"/"&H4&" Assumed Cashflow of $"&R4&"/month|smallred| Negative ROR >5%"))))))))
Please Help
Bookmarks