IF AND in a measure help please

[Pricey79]

Hello , I was hoping someone could help please with an IF statement I am struggling with please.

I have a column called ID's, in this column are ID's that start with numbers, and ID's that start with letters. 

There is another column called State which has various strings.

I need to create a measure that says IF the ID column record begins with a number AND the State is READY , then give me true 

AND if the ID column begins with letters AND the state is COMPLETE, then True, everything else is False.

I then want to put this measure on a visual

Could anyone help with this please?

Manh thanks in advance

[ryan_mayu · Accepted solution]

@Pricey79 

Is this what you want?

Column = 
var _CHECK=IFERROR(LEFT('Table (2)'[ID],1)*1,999)
RETURN IF(_CHECK=999 && 'Table (2)'[State]="COMPLETE" , TRUE(),if(_CHECK<>999&&'Table (2)'[State]="READY",TRUE(),FALSE()))

[Pricey79]

@ryan_mayu exactly spot on! Thank you very much

[ryan_mayu]

you are welcome