Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am try to have an if command search a row of data and then print 1 if it
matchs and a 0 if it doesn't. However the data is a long string of numbers that can be identified after reading the first 3. So instead of having to type it all out I'd like it to do something like. =if(a1=910*,1,0) the * meaning anything after 910 that matches, so if a1 is 910111564 or 910465465 it will return 1, but if it is 911(anything) it will return a 0 Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
wildcard in formula vlookup | Excel Discussion (Misc queries) | |||
Wildcard IF formula | Excel Worksheet Functions | |||
How do I use wildcard characters in Excel 2003 sumif formula? | Excel Worksheet Functions | |||
How do I use a wildcard or multiple of a cell value in a formula? | Excel Worksheet Functions | |||
Wildcard Character in an Array Formula | Excel Discussion (Misc queries) |