title: How to code OTHERS response in excel using ISNUMBER and SEARCH or any other function?
body: <p>=IF(COUNT(FIND({&quot;Saving&quot;,&quot;Bank fixed deposit&quot;,&quot;Public provident fund&quot;,&quot;National saving certificate&quot;,&quot;Post-office saving&quot;,&quot;Government security&quot;},A2)),&quot;FALSE&quot;,&quot;TRUE&quot;). I tried this formula but it returns false when the OTHERS value is present with the values mentioned above.</p>
  <p>Can you please guide me on this?</p>