If A3=alpha numeric,"X", if A3=text,"Y", Blank
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?
|