title: Excel 2007 Formula for True Positive
body: <p>In Excel 2007 I want to calculate True Positive, True Negative, False Positive, False Negative results, based on some criterias. For example if two cells K10 and L10 contains the strings True and True respectively, then will display the Result "True Positive", if False and False = "True Negative" etc.
  Here is the formula but it shows #VALUE .Thanks in advance for any help</p>
  
  <pre><code>=IF(ISNUMBER(SEARCH("TRUE";K10&amp;"TRUE";L10));"True Positive";"False Positive");IF(ISNUMBER(SEARCH("FALSE";K10&amp;"FALSE";L10));"True Negative";"False Negative") 
  </code></pre>