VB Code
 

I need a code that simply looks at cells in Column A and if the cells are
greater than zero than add the following formula to cells in column AN:

IF(COUNTIF(B2,"*Smart
Card*")0,"",IF(COUNTIF(B2,"*CableCard*")0,"",IF( COUNTIF(B2,"*purchase*")0,E2,IF(COUNTIF(B2,"*Conv erter*")0,E2,IF(COUNTIF(B2,"*Box*")0,E2,"")))))

Plz Help!!

Thanks in advance!!

VB Code
 

Do you need< VB code? You can trim down your original formula a
touch, like this:

=IF(OR(B2="*SmartCard*",B2="*CableCard*",B2="*purc hase*",B2="*Converter*",B2="*Box*"),E2,"")

Dave O