Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Yes, No, N/A in formula
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") ,""))) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Yes, No, N/A in formula
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") ,""))) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") ,""))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |