Yes, No, N/A in formula
Thanks again.
The first formula was it.
"Biff" wrote:
Hi!
That formula looks familiar.
Try this:
=IF(COUNT(AC8),"BER",IF(COUNT(AD8),"Canceled",IF(K 8="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(I SNA(K8),"N/A",IF(COUNT(V8),IF(AND(COUNT(J8,K8)=2,J8<=K8),"Yes ","No"),""))))
Biff
"roy.okinawa" wrote in message
...
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(C OUNT(V8),IF(AND(COUNT(J8,K8)=2,J8<=K8),"Yes","No") ,"")))
|