Formula error

[dalviaks]

Hi all, I am receiving formula error in the below, not really sure why, seeking for help.

Formula:
=IF(E53<0,"",IF(OR(D41="Tier 1",D41="Tier 2",D41="Tier 3"),"",(CONCATENATE("Failed following parameter:"&CHAR(10)&((IF(H9=4,C9,"")&CHAR(10)&(IF(H10=4,C10,"")&CHAR(10)&(IF(H11=4,C11,"")&CHAR(10)&(IF(H12=4,C12,"")&CHAR(10)&(IF(H13=4,C13,"")&CHAR(10)&(IF(H14=4,C14,"")&CHAR(10)&(IF(H16=4,C16,"")&CHAR(10)&(IF(H17=4,C17,"")&CHAR(10)&(IF(H18=4,C18,"")&CHAR(10)&(IF(H20=4,C20,"")&CHAR(10)&(IF(H21=4,C21,"")&CHAR(10)&(IF(H22=4,C22,"")&CHAR(10)&(IF(H23=4,C23,"")&CHAR(10)&(IF(H24=4,C24,"")&CHAR(10)&(IF(H25=4,C25,"")&CHAR(10)&(IF(H26=4,C26,"")&CHAR(10)&(IF(H27=4,C27,"")&CHAR(10)&(IF(J28=4,C29,"")&CHAR(10)&(IF(J29=4,C30,"")&CHAR(10)&(IF(H31=4,C31,"")&CHAR(10)&(IF(H32=4,C32,"")&CHAR(10)&(IF(H33=4,C33,"")&CHAR(10)&(IF(H34=4,C34,"")&CHAR(10)&(IF(H35=4,C35,"")&CHAR(10)&(IF(H36=4,C36,"")&CHAR(10)&(IF(H37=4,C37,"")&CHAR(10)&(IF(H38=4,C38,"")&CHAR(10)&(IF(H39=4,C39,"")&CHAR(10))))))))))))))))))))))))))))))))))

 

[CSmith]

What are you trying to do with this?

 

[Michael M]

What error are you receiing ?
What are you actually trying to do with this formula ??
A SMALL sample of your data relating to this formula might help as well !!

 

[Michael M]

I don't get an error, but have you turned Wrap text on ??
Rclick cell>>format>>alignment>>Tick wrap text>>OK