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,

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td]

123​

[/td][td="bgcolor:#CCFFCC"]OK[/td][td]B1: =IF((LEFT(A1) >= "1") * (LEFT(A1) <= "9"), "OK", "Error")[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]ABCDE[/td][td="bgcolor:#CCFFCC"]Error[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]012[/td][td="bgcolor:#CCFFCC"]Error[/td][td][/td][/tr]
[/table]

 

[shg]

Or ...

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td]

123​

[/td][td="bgcolor:#CCFFCC"]OK[/td][td]B1: =IF(MEDIAN(49, CODE(A1), 57) = CODE(A1), "OK", "Error")[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]ABCDE[/td][td="bgcolor:#CCFFCC"]Error[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]012[/td][td="bgcolor:#CCFFCC"]Error[/td][td][/td][/tr]
[/table]

 

[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!