I need to set up an IF formula for a series on account numbers- the first 4
digits of the # are the same, the last 2 change but all are included in the
answer. I have several series of numbers to include:
example:
1234-01 through 1234-99
and
2007-01 through 2007-99
and
3010-01 through 3010-99
Any help you could give me would be appreciated