Excel Formula to find specific text but exclude others

Question

I have an excel file which says

Description | 
A
A
A
A
non-A
B
B
B
C
D
E
F

I am trying to do a formula which it will only considers those which are a so i did this.

    =ISNUMBER(SEARCH("*a*",[Description]))

But it ended up like this

Description | Consider?
    A             Yes
    A             Yes
    A             Yes
    A             Yes
    non-A         Yes
    B             No
    B             No
    B             No
    C             No
    D             No
    E             No
    F             No

What I want to achieve is this

Description | Consider?
A             Yes
A             Yes
A             Yes
A             Yes
non-A         No
B             No
B             No
B             No
C             No
D             No
E             No
F             No

Answer 1

You can try this

=IF([Description]="A","Yes","No")

where [Description] is the range like for example A11:A22

Answer 2

Try...

=IF(A2="A","Yes","No")

Hope this helps!