If Statement: Variable Character Length

[Budge]

I need a modification to the formula below please.If the cell reference,$C2 is 4 characters or less then perform the function.If not,enter null.The characters are numbers.
I was working with Mid,Left,Right functions but was unable to work it.
Suggestions appreciated

=IF(ISBLANK($C2),"",IF(AND(BC2=BG2,BC2=BK2),"MrExcelRocks","Change"))

Best Regards
Budge

 

[Savanur]

=IF(len($C2)>4,"",IF(AND(BC2=BG2,BC2=BK2),"MrExcelRocks","Change"))

 

[gwkenny]

If the cell entry is a number, and you want to see if it is greater than 4 characters long, and the entry is an integer, couldn't you also test to see if it is > 9999

I wonder if testing if the cell number is > 9999 is faster than using the LEN function.

g-

 

[Budge]

Too easy.Thanks alot


Best regards
Budge