Should say:

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

"Iriemon" wrote:

2nd question:

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

Irie



"Pam M" wrote:

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