This content has been marked as final. Show 2 replies
i have a line of code as such:
if(RC_COUNTRYNAME='Japan',if (RC_TITLE='Executive Summary',if(RC_KPI='Overall',IF(len(RC_RGNL_CMNTS)=0 AND len(RC_CNTRY_CMNTS)=0,'NO COMMENTS AVAIL',IF(len(RC_RGNL_CMNTS)=0 ,RC_CNTRY_CMNTS,RC_RGNL_CMNTS)))))
so. problem i m having now is, for RC_COUNTRYNAME , i want to add more than 1 country, like 'Japan', 'Korea','India'. How can i rectify that?