Is this any better?

=IF(ISNA(MATCH(D3,{"6A","3G","4G","5G","6G","6L"," SS","3T","4T","5T","6T","NIL"},0)),IF(D3="3A",C3*E 2,"Not
equal to 6A or 3G or 4G or 5G or 6G or 6L or SS or 3T or 4T or 5T or 6T or
NIL"),"")

"George" wrote:

Excel 2009
Is there any way I can shorten this formula?
=IF(OR(D3="6A",D3="3G",D3="4G",D3="5G",D3="6G",D3= "6L",D3="SS",D3="3T",D3="4T",D3="5T",D3="6T",D3="N IL"),"",IF(D3="3A",C3*E2,"Not
equal to 6A or 3G or 4G or 5G or 6G or 6L or SS or 3T or 4T or 5T or 6T or
NIL"))