Support with If Function

Hi,

Perhaps something like this

=IF(OR(RIGHT(TRIM(C2),1)="9",
      RIGHT(TRIM(C2),1)="X"),"No Pay Run",
   IF(AND(TRIM(I2)="",
      LEN(TRIM(C2))=1,
      OR(TRIM(C2)<>"C",
         TRIM(C2)<>"K")),"MDI",
   IF(OR(TRIM(C2)="GM"),"IC Pay Run",
   IF(OR(RIGHT(TRIM(C2),1)="T",
      RIGHT(TRIM(C2),1)="U"),"F",
   IF(OR(RIGHT(TRIM(C2),1)="C",
      RIGHT(TRIM(C2),1)="D",
      RIGHT(TRIM(C2),1)="P",
      RIGHT(TRIM(C2),1)="Q",
      RIGHT(TRIM(C2),1)="E",
      RIGHT(TRIM(C2),1)="B",
      RIGHT(TRIM(C2),1)="X",
      RIGHT(TRIM(C2),1)="S",
      RIGHT(TRIM(C2),1)="K"),"D","MDI")
))))

if not simplify the rest