Thread: if statement for number of digits
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Iriemon Iriemon is offline
external usenet poster
  
Posts: 89
Default if statement for number of digits
=if(a1999,"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
Reply With QuoteReply With Quote