Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 03 Jun 2012 13:38:33 +0200- problem with conditionalhttps://ask.libreoffice.org/en/question/3067/problem-with-conditional/I have a problem with de function "if"
I edit 3 consecutives cells with the same value:
1234 e.g.
B1347 1234
B1348 1234
B1349 1234
in another cell i write the funtion: =IF(B1347=B1348=B1349;1;0)
the function always returns 0, but the values are the same.
What i doing wrong?
P.S:
i created a new spreadsheet and i tried to do the same.
I edited 3 consecutives cells with the same value:
1234 e.g.
A1 1234
A2 1234
A3 1234
in another cell I wrote the function: =IF(B1347=B1348=B1349)
The function returned the value FALSE
but when i edited A1 and put the value 1, the function returned the value TRUE
I tried other combinations, and only when the first cell that appears in the function was 1, the function returns TRUE.
note: i am Brazilian and i use the portuguese version of CalcAndrĂ© CamargoSun, 03 Jun 2012 13:38:33 +0200https://ask.libreoffice.org/en/question/3067/