title: comparing three cells in openoffice calc. (i'd be happy with 2)
body: <p>I need to do a simple function that is driving me nuts.
  I have 3 columns with cells filled as follows. </p>
  
  <p>I2 Y
  I3 N
  I4 Y</p>
  
  <p>I am looking for every row that has N N N. I'm trying to formulate it so I can do a visual inspection but (baby steps) my first stage is failing. I'm trying </p>
  
  <p>=IF(I2='N';'Y';'N')</p>
  
  <p>In this case the output should be 'Y', Instead I'm getting #VALUE.</p>
  
  <p>Any pointers? </p>