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!!
|