IF statement if not in a specific format

[surkdidat]

Is it possible to have a cell in an IF statement populate text if it is not in the following format ABC_12345 (ie Letter, letter, letter, underscore, number, number, number, number, number)

The same three letters will always start the format, then always an underscore, then a 5 digit number, the first will always be a 1.

If it is in any other format, or additional characters such as brackets etc are added, i need a message displayed

This needs to be in a formula, rather than using Data Validation, or conditional formatting etc, as for some reason the programme the spreadsheet is uploaded into doesn't like that!

So, I need something that basically is

= IF(C2<>"ABC_12345,"Wrong format","Correct format")

- with the emphasis of the TRUE bit being if it does not match

 

[Peter_SSs]

See if this does what you want. If not, more examples and explanation please.

23 08 25.xlsm
	A	B
1	ABC_12345	Correct
2	ABC_42346	Wrong
3	XXX_12345	Wrong
4	ADC_123456	Wrong
5	ADC_123(57	Wrong
6	ADC_123-5	Wrong
7	ABC_19999	Correct
8	ABC_123	Wrong
Check Format

Cell Formulas
Range	Formula
B1:B8	B1	=IF(AND(LEFT(A1,5)="ABC_1",LEN(A1)=9,ISNUMBER(MID(A1,6,1)+MID(A1,7,1)+MID(A1,8,1)+MID(A1,9,1))),"Correct","Wrong")