don't know much about Excel 2009

but in previous versions the following procedure would work:

in an unused range of a worksheet make a list of 6A, 3G, 4G,..., NIL
etc.

select that range, give it a name (Insert-Name-Define in Excel 2003)
by inserting a name "thelist" in name manager

the yr formula might be like:

=IF(COUNTIF(thelist,D3)0,"",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"))

HIH


On 27 Lut, 15:27, 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=" NIL"),"",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"))