IF conditon on numeric and alphanumeric

**emina002** · 06-13-2012, 03:50 AM

I have a column for example consist of Numeric,Alphanumeric and Alpha(String/Text) as data, the thing is on the other column I put a conditional statement that if a cell is Numeric or Alphanumeric it should copied the content of that cell,if its text or pure alpha character it should return "No TIN"

here is the piece of my condtion, i need to add something for alphanumeric condition. I hope you can help me,Thanks!

Please Login or Register  to view this content.

**Md Aejaz** · 06-13-2012, 03:59 AM

Hi

=IF(ISNUMBER(A1),A1,"NO TIN")

you can't change the Content of cell through Conditional formatting.

only u can change the appearance of cells.

try the above formula hope u will get the answer.

Please select star from below if it u r satisfied.

**FDibbins** · 06-13-2012, 04:00 AM

for the pure numeric, try =if(isnumber(A2),A2,"No Tin")
for alpha use =if(istext(A2),A2,"No Tin")

**benishiryo** · 06-13-2012, 04:17 AM

hi emina002, my understanding seems to be different, so i'm not sure if this is what you need. Create a series of numbers from 0-9 in F1:F10. And assuming if your data is in A2, this is the formula to use in B2:
=IF(SUMPRODUCT((ISNUMBER(FIND($F$1:$F$10,A2)))*1)>0,A2,"NO TIN")