Determine if first character in string is greater than zero

[BillTony]

I have a dataset with numerous combinations of alpha and numeric values in a given column.

I need to do TWO things.

1) Determine if the 1st character is numeric - if so, the initial condition is met.

2) If numeric, is the character between 1 and 9 (greater than 0) - if so, the final condition is met and the record receives a "Pass."

I'm supplying 2 lines of code that seem to work equally well at handling the initial condition.

It's the final condition that's giving me pain...

Thanks in advance!

=IF(ISERR(LEFT(AO3,1)*1),"ERROR","OK")

=IF(ISNUMBER(VALUE(LEFT(AO3,1))),"OK","ERROR")

 

[dreid1011]

Perhaps this:

=IF(ISNUMBER(LEFT(AO3,1)*1),IF(LEFT(AO3,1)*1>0,"OK","ERROR"),"ERROR")

Or

=IF(AND(ISNUMBER(LEFT(AO3,1)*1),LEFT(AO3,1)*1>0),"OK","ERROR")

 

[shg]

Similarly,

	A​	B​	C​
1​	123​	OK	B1: =IF((LEFT(A1) >= "1") * (LEFT(A1) <= "9"), "OK", "Error")
2​	ABCDE	Error
3​	012	Error

 

[shg]

Or ...

	A​	B​	C​
1​	123​	OK	B1: =IF(MEDIAN(49, CODE(A1), 57) = CODE(A1), "OK", "Error")
2​	ABCDE	Error
3​	012	Error

 

[BillTony]

Thanks - you just made my day!

 

[Rick Rothstein]

I know I am late to the party, but here is one more formula that you can consider...

=IF(0+LEFT(A1)>0,"OK","Error")

 

[BillTony]

Never too late!

Thanks - nice compact solution!