if statement for number of digits

[Pam M]

I need help writing an if statement. I would like to say:

If(A1 = a 4 digit number,"UNAPPROVED","")

How do I designate the 4 digit number in the formula?

Also, for another statement, I want to say "begins with 4, 5, 6, or 9, give
me "","unapproved".

Thanks,Pam

 

[Iriemon]

=if(a1>999,"Unapproved","")

Irie

 

[Iriemon]

2nd question:

=if(or(a1=4,a1=5,a1=6,a1-9),"unapproved","")

Irie

 

[NBVC]

Try these

=IF(Len(A1)=4,"Unapproved","")

=IF(OR(Left(A1)+0={4,5,6,9}),"","Unapproved"

 

[Iriemon]

Should say:

=if(or(a1=4,a1=5,a1=6,a1=9),"unapproved","")

 

[Jacob Skaria]

Shouldnt that be

=IF(ISNA(MATCH(LEFT(A1,1),{"4","5","6","9"},0)),"","UnApproved")

since the OP has asked for ""I want to say "begins with 4, 5, 6, or 9, give

me "","unapproved".""""

If this post helps click Yes

 

[Pam M]

Both of these items worked perfectly, and were the most concise of the
choices. thank you all for your help, Pam