Hi,
I have 6 cells in an excel worksheet that I am interested in. I need to check if these 6 cells START with 531, 532, 533 OR 534. If it does start with one of these numbers, input a 1, otherwise input a 0.
For example, a cell with the value of:
534929 would give me a 1
953429 would give me a 0
3945 would give me a 0
532 would give me a 1
So far, I have been able to check one cell if it starts with one pattern of numbers (531 in this case) using this formula:
=If(ISNUMBER(SEARCH(531,(LEFT(CELLNUMBER,3)))),1,0)
However, I am unsure how to incorporate more columns/number patterns into this formula.
Can anyone help me with this?
Thanks.
Bookmarks