I have a list to check if business directory has been entered correctly. Criteria is:
Include 6 numbers = "correct"
More than 6 numbers = "incorrect"
Less than 6 numbers = "legacy"
Note: I the cell includes any letter it should be recognised as "incorrect"
I am experiencing problems if the cell contains a letter e.g. A12345 or B54321. My formula notes them as "correct":
Please can someone help?
Include 6 numbers = "correct"
More than 6 numbers = "incorrect"
Less than 6 numbers = "legacy"
Note: I the cell includes any letter it should be recognised as "incorrect"
I am experiencing problems if the cell contains a letter e.g. A12345 or B54321. My formula notes them as "correct":
Excel Formula:
IF(LEN(C2)=6,"correct",IF(LEN(C2)>6,"incorrect", IF(LEN(C2)<6,"legacy","")))
Please can someone help?