in column B use

="case " & left(A1,1)

I cannot see the logic behind the results you describe for column C.
Perhaps you can clarify that a little - or a lot.

"Curalice" wrote:


In Col A, I have a list of 3 digit numbers eg:
110
111
112
113
115
116
120
Some numbers begin with 1, some with 2, 3 or 4.

I have two formula problems:

In Col B I want a formula to return "case 1, if the number begins with
1, "case 2" if 2, etc.
I tried variations of this formula but it I am missing something.
=IF((LEFT(A1)="4","case 4",""),(LEFT(A1)="3","case
3",""),(LEFT(A1)="2","case 2",""),(LEFT(A1)="1","case 1",""))

In Col C I want a similar result, except that "case 5", "case 6" etc.
would be correct for a mix of numbers, eg "case 5" would be the answer
for, say, any of 110 trrough 115, 315, 330, 410 or 411.

I hope that is clear. I am sure this is simple, but I am confused and
appreciate the help.
Thanks.


--
Curalice
------------------------------------------------------------------------
Curalice's Profile: http://www.excelforum.com/member.php...o&userid=28600
View this thread: http://www.excelforum.com/showthread...hreadid=503036