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?