Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is it possible to use wildcards in an IF function to test a text string in a
cell. I have a cell that could contain 2 text string options "300 Denier Polyester" or "600 Denier Polyester" Because the operators who input this text may write it in different ways (300 Denier Polyester or Polyester 300 Denier) I would like to write an IF function in another cell that tests the cell in question for whether the string contains 300 or 600 and depending on the result, perform a different calculation |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Wildcards and if | Excel Worksheet Functions | |||
Wildcards in SUMIF Function | Excel Worksheet Functions | |||
Wildcards in RTD | Excel Discussion (Misc queries) | |||
Can wildcards be used in the Logic Test of an Excel "IF" function? | Excel Worksheet Functions | |||
Problems with SUMIF function and Wildcards (* and ?) | Excel Worksheet Functions |