If + and + len?

[cjvenables]

Hey guys,

I need a formula that will check if what is in C2 is 7 digits, but does not equal 7 characters. If it equals 7 numbers, I want it to return, "7 Numbers", if not, "NOTHING"

Here is the formula I am working with:

=IF(LEN(C2)=7,"7 Digits","NOTHING")

This works for everything, but when a cell had 7 letters (CLEANFX), it would return 7 digits. I need something that only finds 7 numbers. I am probably using the wrong formula?

I tried to use this formula, but it returned CLEANFX, but not the cells that had 7 numbers.

=IF(AND(LEN(C4)=7,C4="CLEANFX"), "7 Digits", "NOTHING")

Thanks for the help!

 

[pibb55]

You can check if its a Number with "ISNUMBER()"

=IF(AND(LEN(C2)=7,ISNUMBER(C2)),"7 Digits","NOTHING")