IF-Then statement help

[nethermit]

Need help on how to formulate an if-then condition with an alphanumeric dataset.

Data
A1= XYC75007942
A2= XYC75007494
A3= BTA75041970
A4= BTA75029975
A5= MAA00176

If the data format is XXX75###### if true, then return "correct", otherwise "incorrect"
So, using the example data above, cell A1 to A4 should return "correct".

A little help please?

 

[AlphaFrog]

This checks if the characters in positions 4 and 5 equal 75 and if the length of the all the text is 11 characters and if all the characters from 4 to 11 are numeric. This works for your example data.

=IF(AND(LEN(A1)=11,MID(A1,4,2)="75", ISNUMBER(VALUE(MID(A1,4,8)))),"Correct","Incorrect")

It doesn't check if the 1st three characters are alpha. That could be added if really needed.

 

[nethermit]

Precisely! Thank you!