comparing three cells in openoffice calc. (i'd be happy with 2)

I need to do a simple function that is driving me nuts. I have 3 columns with cells filled as follows.

I2 Y I3 N I4 Y

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

=IF(I2='N';'Y';'N')

In this case the output should be 'Y', Instead I'm getting #VA开发者_运维问答LUE.

Any pointers?

try using double quotes and that should do it

=IF(A1="y";"y";"n")

this works for me