title: How to use logical operator on range of cells in Excel (#VALUE error message)
body: <p>I have a range of cells that I want to oversee whether it is within specs or out of specs.</p>
  
  <p>I try using the single cell to evaluate and so far so good. It should evaluate whether the cell are within values of 10 and 15, if it is within PASS, else FAIL.</p>
  
  <pre><code>=IF(OR(A2&lt;10,A2&gt;15),"FAIL","OK")
  </code></pre>
  
  <p>When I try with range itself (A2:Z2) , it also couldn't work as it shown #VALUE error message.</p>
  
  <pre><code>=IF(OR(A2:Z2&lt;10,A2:Z2&gt;15),"FAIL","OK")
  </code></pre>
  
  <p>I try with Name Range itself, "Ctrl+F3" (I named it TEST) , it comes out with same results</p>
  
  <pre><code>=IF(OR(TEST&lt;10,TEST&gt;15),"FAIL","OK")
  </code></pre>
  
  <p>May I know if there are any ways I can evaluate the whole range ? </p>