# Yes, No, N/A in formula

G

#### Guest

Here is a formula that was provided to me. It works great. However, after
reconciling my data I found that some cells in column K will need to have a
N/A vice a number. Therefore, the below formula (in cloumn C) is reading the
N/A and providing a false "No". Actually if there is a N/A in column K then
the formula should also provide a N/A instead of a Yes or No. What needs to

B

#### Biff

Hi!

That formula looks familiar.

Try this:

I'm assuming that the N/A is a text entry and not a logical value.

If it is in fact the logical #N/A, then:

Biff

G

#### Guest

Thanks again.

The first formula was it.

Biff said:
Hi!

That formula looks familiar.

Try this:

I'm assuming that the N/A is a text entry and not a logical value.

If it is in fact the logical #N/A, then: