So I figured it out after using the formula that JBeuacaire gave me and then adding a section. See below:

=IF(ISNUMBER(MATCH(G3,{"B","C","LC","LCN","M","NLC","PP"},0)),"Not Changed",IF(P3<$Q$1,IF(AND(ISNUMBER(MATCH(M3,{"C","EW"},0))*(G3="T")),E3-($R$1-E3),E3-S3),"Not Changed"))

What I changed is in bold.

Thanks guys for the help.