MID formula

[melayruiz]

Hi everyone! I just need a little help. I was given this formula =IF(MID(A21,13,3)="DA1","yes",IF(MID(A21,13,3)="D01","yes","no")) and the question is this "The formula in cell C21 show be indicate yes if the data on cell A21 contains DA1. Correct the formula" the data in A21 is R2D2ETR2X2N9D01DA1ZQB631. Can anyone explain to me this formula? a big thanks!

[jeffreybrown]

Hello & Welcome to the Board,

Excel help does a great job not only explaining this function but many others

=MID(text,start_num,num_chars)

Look at A21 >> start at number 13 >> length - three characters >> does it equal your sought after value

Another useful tool is Evaluate formula

[tkowal]

Your formula only checks character position 13 for a length of 3 characters: In your examples the 13th character is D length of 3 makes it "D01".

substituting the MID(....) for above "D01":

=if("D01" = "DA1","yes",If("D01" = "D01"),"yes","no")
so in you example the result will be "yes"

As for correcting it we would need to know the rules for yes and no.