title: Can I use OR in LibreOffice calc IF statement?
body: <p>I'm trying to achieve something like:</p>
  
  <p>=IF( N2="string1", "high", IF( N2="string2" or N2="string3","middle","low") )</p>
  
  <p>Or, in psuedo code:</p>
  
  <pre><code>String input = &lt;some value&gt;
  if( input.equals("string1") ) {
       return "high"
  } else if ( input.equals("string2) || input.equals("string3") ) {
      return "middle"
  } 
  return "low"
  </code></pre>
  
  <p>Any idea how I can do that using a spreadsheet (Libre Office Calc ideally) formula rather than code?
  Where the input variable would obviously be a cell reference.</p>