Recognising Number or Letters

[Steve 1962]

Hi

How do I get an IF statement to handle numbers differently to letters.

EG:

IF(A1=a number, then it does this......
IF(A1=a letter, then it does this.......

Thanks

 

[Rick Rothstein]

If I understand the request correctly, I think this normally-entered formula placed in cell K2 and copied down should also work...

=IF(ISTEXT(L2),MAX(K$1:K1)+1,"")

 

[Peter_SSs]

Clearly explained - thanks Peter.

 

[Peter_SSs]

If I understand the request correctly, I think this normally-entered formula placed in cell K2 and copied down should also work...

=IF(ISTEXT(L2),MAX(K$1:K1)+1,"")

I think you may have missed ..

values in column L are generated by a formula

.. I'm presuming that means all those 'blank' cells in column L are "", which would return True for ISTEXT() & produce a very different result to that shown in the post 4 image.