| 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!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| 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 | |||
Linear Mode
