Formula: Yes or No IF cell contains one of two letters

[RaveMonkey]

Hi,

I am trying to create a formula that will check a cell to see if i
contains one of two letters followed by three numbers. If this is tru
I want the word Yes returned and No if not.

Example Data:

A B

D123 Yes
N456 Yes
STN0356 No
NK592269 No

In these examples D123 and N456 would return a Yes and the others
No.

Suggestions?

RaveMonke

 

[Guest]

Hi

Quick and dirty!
Try something like this:
=IF(AND(LEN(A2)=4,ISNUMBER(N(RIGHT(A2,3))),NOT(ISNUMBER(LEFT(A2,1)))),"Yes",
"No")
There are probably nicer ways of doing it!!

 

[Jerry W. Lewis]

=IF((LEN(A1)=4)*LEN(VALUE(RIGHT(A1,3)))*ISNUMBER((FIND(LEFT(A1,1),"DN"))),"Yes","No")

Jerry

 

[RaveMonkey]

Thanks, I'll give that a try! As long as it's works dirty is good!

R