title: How to derive a column based on multiple columns values for a single row
body: <p>I currently have an issue with a calculation I'm trying to create.</p>
  
  <p>So I have 8 columns, all with the same 3 values: </p>
  
  <pre><code>1 = pass   , 2 = borderline  , 3 = Fail.
  </code></pre>
  
  <p>I need to be able to calculate a new column which will state the following: </p>
  
  <pre><code>Pass = All 8 fields equals '1'  
  Borderline = 7 Fields that equal '1' with one field that equals '2' 
  Else Fail
  </code></pre>
  
  <p>It seems a easy calculation but I keep tripping up on the borderline logic, as any of the 8 columns could have the '2'? </p>
  
  <p>Any help would be much appreciated. </p>