Search code examples
libreofficelibreoffice-calc

How to use OR condition in LibreOffice?

I am trying to use the formula below to set conditions in LibreOffice but I keep getting an error. What am I doing wrong with the statement below:

=IF(G2<=2,'negative',IF(OR(G2>2 & G2<=3,'neutral',IF(OR(G2>=4,'positive))))))

Thanks

Solution

  • It seems, that in your formula is missing the last ':

    'positive))))))

    should be 'positive'))))))

    Also the

    &

    is string-concatenation in LibreOffice, so you need here the equivalent to OR() and that is AND().

    But you can simplify your formula to

    =IF(G2<=2,'negative',IF(AND(G2>2,G2<=3),'neutral','positive'))

    The first test is if the number is lower than 2 (negative),
    the second test is if the number is between 2 and 3 (neutral)
    and then there is no further test needed as it is the only remainig possiblity.