Thread: VB Code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael Michael is offline
external usenet poster
 
Posts: 791
Default 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!!