 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / June 2007One question
If either column A has "yes" or column B has "yes", column C should show "yes" too but if BOTH columns "A" or "B" have "N/A" "C" should say "N/A", A B C Yes no yes No Yes Yes Yes Yes Yes No no No N/A N/A N/A I tried =IF(OR(a1="Yes",b1="Yes"),"Yes","No") it is giving me A B C Yes no yes No Yes Yes Yes Yes Yes No no No N/A N/A no C5 is the thing I want to change from "no" to "NA" Try one of these: =IF(COUNTIF(A1:B1,"n/a")=2,"N/A",IF(COUNTIF(A1:B1,"yes"),"Yes","No")) =IF(AND(A1="n/a",B1="n/a"),"N/A",IF(OR(A1="yes",B1="yes"),"Yes","No")) Copy down as needed Biff > If either column A has "yes" or column B has "yes", column C should show > "yes" too but if BOTH columns "A" or "B" have "N/A" "C" should say "N/A", [quoted text clipped - 17 lines] > > C5 is the thing I want to change from "no" to "NA" an body please? > If either column A has "yes" or column B has "yes", column C should show > "yes" too but if BOTH columns "A" or "B" have "N/A" "C" should say "N/A", [quoted text clipped - 17 lines] > > C5 is the thing I want to change from "no" to "NA" > If either column A has "yes" or column B has "yes", column C should show > "yes" too but if BOTH columns "A" or "B" have "N/A" "C" should say "N/A", [quoted text clipped - 17 lines] > > C5 is the thing I want to change from "no" to "NA" Your question is a follow up to one you asked in an earlier thread... it would have been better to keep your question in that original thread. Anyway, just so you are aware, the text string "N/A" is not the only problem text... for the above formula that you tried (which is the one JE McGimpsey posted in that earlier thread), any piece of text that is not the word "yes" will cause a problem. Similarly, the formula I posted in that earlier thread will cause problems whenever a piece of text that is not the word "no" is used. You never mentioned if "yes" and "no" were the only possible entries, but your example suggested it was, so we provided answers to match that. If you have **other** conditions that you need to account for, you should mention them in your question when you first ask it... that would save you the time and trouble of having to come back here like you did in this thread. So... are there any other conditions you need to account for? Rick If you want help here, you need to ask questions with a meaningful subject line and stay in the original thread and show a bit of patience.  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > If either column A has "yes" or column B has "yes", column C should show > "yes" too but if BOTH columns "A" or "B" have "N/A" "C" should say "N/A", [quoted text clipped - 17 lines] > > C5 is the thing I want to change from "no" to "NA" |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.