Please help.

I got following formula:

IF(MID(A238,5,4)="TEST", IF(A237="CTAG",A236,J237)," ")

This works for me, but in first call, i would like to next more ifs, for example:

IF(MID(A238,5,4)="TEST",
IF(MID(A238,5,5)="TEST1",
IF(MID(A238,5,3)="TES,
IF(MID(A238,5,7)="TEST123",

and end with, IF(A237="CTAG",A236,J237)," ")