Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: For Count, when count changes from cell to cell | Excel Discussion (Misc queries) | |||
Cell value not recognized by code. | Excel Discussion (Misc queries) | |||
Text formatting | Excel Worksheet Functions | |||
VLOOKUP for Zip Code Ranges | Excel Worksheet Functions | |||
Macro for changing text to Proper Case | Excel Worksheet Functions |