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
be added?

=IF(COUNT(AC8),"BER",IF(COUNT(AD8),"Canceled",IF(COUNT(V8),IF(AND(COUNT(J8,K8)=2,J8<=K8),"Yes","No"),"")))
 
Ad

Advertisements

B

Biff

Hi!

That formula looks familiar.

Try this:

=IF(COUNT(AC8),"BER",IF(COUNT(AD8),"Canceled",IF(K8="N/A","N/A",IF(COUNT(V8),IF(AND(COUNT(J8,K8)=2,J8<=K8),"Yes","No"),""))))

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:

=IF(COUNT(AC8),"BER",IF(COUNT(AD8),"Canceled",IF(ISNA(K8),"N/A",IF(COUNT(V8),IF(AND(COUNT(J8,K8)=2,J8<=K8),"Yes","No"),""))))

Biff
 
Ad

Advertisements

G

Guest

Thanks again.

The first formula was it.

Biff said:
Hi!

That formula looks familiar.

Try this:

=IF(COUNT(AC8),"BER",IF(COUNT(AD8),"Canceled",IF(K8="N/A","N/A",IF(COUNT(V8),IF(AND(COUNT(J8,K8)=2,J8<=K8),"Yes","No"),""))))

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:

=IF(COUNT(AC8),"BER",IF(COUNT(AD8),"Canceled",IF(ISNA(K8),"N/A",IF(COUNT(V8),IF(AND(COUNT(J8,K8)=2,J8<=K8),"Yes","No"),""))))

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

YES or NO formulas 3
Yes No formula 2
If formula with Yes or No 1
Formula to answer YES or No 4
Formula erros =#N/A 2
Formula for top n 2
Formula returning #N/A 4
Array formula and #N/A 6

Top