Hi guys,

I am new here at using Open Office. But then i have a problem on my sheet. As you see in this formula, =IF(C3=0;"ACCURATE";IF(AND((C3)OR(F3))<=-1;"NEGATIVE VARIANCE";IF(AND((C3)OR(F3))>=1;"POSITIVE VARIANCE")))

Both C3 and F3 have result from my vlookup, so the result ive been talking is negative and positive numbers.

"ACCURATE" "POSITIVE VARIANCE" "NEGATIVE VARIANCE" are my result if the number I expected based on my formula will set.

I want to make comparison on c3 and f3 cell for which/whomever on c3 or f3 is <= -1, the selected cell will appear as negative variance.

Based on my formula, it worked but my problem is when i encounter likewise on my expected result, the comment appeared is positive variance.

I dont really know if I can make the negative number based on my formula reads the value of c3 or f3 as lower than zero.

Is that even posible or should I revise my formula?

What should I do? Please help me guys i am new and start to explore ☹️ thank you!