VB Code

M

Michael

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,"*Converter*")>0,E2,IF(COUNTIF(B2,"*Box*")>0,E2,"")))))

Plz Help!!

Thanks in advance!!
 
D

Dave O

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

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

Dave O
 
Top