ISNUMBER is not working because the value is alpha numeric. for example --
E456

Thanks
Gary

"Bob Phillips" wrote in message
...
Keep it simple

=IF(ISNUMBER(A3),"X",IF(A3="Y",""))

what about if not a number and not Y?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary" wrote in message
...
Ok.....this is what am trying to do.

If A3=alpha numeric,"X", if A3=text,"Y", Blank

any ideas?

That is exactly the point I was making, it is not a number, not Y, so what
do you want the formula to return in this case?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary" wrote in message
...
ISNUMBER is not working because the value is alpha numeric. for example --
E456

Thanks
Gary

"Bob Phillips" wrote in message
...
Keep it simple

=IF(ISNUMBER(A3),"X",IF(A3="Y",""))

what about if not a number and not Y?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary" wrote in message
...
Ok.....this is what am trying to do.

If A3=alpha numeric,"X", if A3=text,"Y", Blank

any ideas?

all i wanna do is. if A3 has an alpha numeric value(E344) then the cell
should return X. if A3 has text then it should return Y

"Bob Phillips" wrote in message
...
That is exactly the point I was making, it is not a number, not Y, so what
do you want the formula to return in this case?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary" wrote in message
...
ISNUMBER is not working because the value is alpha numeric. for
example --
E456

Thanks
Gary

"Bob Phillips" wrote in message
...
Keep it simple

=IF(ISNUMBER(A3),"X",IF(A3="Y",""))

what about if not a number and not Y?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary" wrote in message
...
Ok.....this is what am trying to do.

If A3=alpha numeric,"X", if A3=text,"Y", Blank

any ideas?

Then all you need is

=IF(ISNUMBER(A3),"X","Y")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary" wrote in message
...
all i wanna do is. if A3 has an alpha numeric value(E344) then the cell
should return X. if A3 has text then it should return Y

"Bob Phillips" wrote in message
...
That is exactly the point I was making, it is not a number, not Y, so
what
do you want the formula to return in this case?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary" wrote in message
...
ISNUMBER is not working because the value is alpha numeric. for
example --
E456

Thanks
Gary

"Bob Phillips" wrote in message
...
Keep it simple

=IF(ISNUMBER(A3),"X",IF(A3="Y",""))

what about if not a number and not Y?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary" wrote in message
...
Ok.....this is what am trying to do.

If A3=alpha numeric,"X", if A3=text,"Y", Blank

any ideas?

its not working bob....i want X if the value in A3 is like E344 or F678 etc.
ISNUMBER is not taking it as a number.

Thanks for the help.

"Bob Phillips" wrote in message
...
Then all you need is

=IF(ISNUMBER(A3),"X","Y")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary" wrote in message
...
all i wanna do is. if A3 has an alpha numeric value(E344) then the cell
should return X. if A3 has text then it should return Y

"Bob Phillips" wrote in message
...
That is exactly the point I was making, it is not a number, not Y, so
what
do you want the formula to return in this case?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary" wrote in message
...
ISNUMBER is not working because the value is alpha numeric. for
example --
E456

Thanks
Gary

"Bob Phillips" wrote in message
...
Keep it simple

=IF(ISNUMBER(A3),"X",IF(A3="Y",""))

what about if not a number and not Y?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary" wrote in message
...
Ok.....this is what am trying to do.

If A3=alpha numeric,"X", if A3=text,"Y", Blank

any ideas?

Gary wrote:
all i wanna do is. if A3 has an alpha numeric value(E344) then the cell
should return X. if A3 has text then it should return Y


Hi Gary

As far as Excel is concerned, E344 is text.

If your alpha numerics are always the same format (i.e the second
character is a number), you can try:

=IF(ISNUMBER(MID(A3,2,1)*1),"X","Y")

Regards

Steve

wow steve..i tried MID but dint do *1.

it worked...thanks a ton

"Scoops" wrote in message
oups.com...

Gary wrote:
all i wanna do is. if A3 has an alpha numeric value(E344) then the cell
should return X. if A3 has text then it should return Y


Hi Gary

As far as Excel is concerned, E344 is text.

If your alpha numerics are always the same format (i.e the second
character is a number), you can try:

=IF(ISNUMBER(MID(A3,2,1)*1),"X","Y")

Regards

Steve

"Gary" skrev i en meddelelse
...
all i wanna do is. if A3 has an alpha numeric value(E344) then the cell
should return X. if A3 has text then it should return Y



Hi Gary

Maybe this one:

=IF(ISNUMBER(A3)+(A3=""),"",IF(MIN(LEN(SUBSTITUTE( A3,{0,1,2,3,4,5,6,7,8,9},"")))<LEN(A3),"X","Y"))


--
Best regards
Leo Heuser

Followup to newsgroup only please.