Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Why, in French, does the combo of functions SI(EXACT(cell1,text);cell2;cell3) returns a boolean instead of cell2 or cell3?

LibreOffice 4.2.8.2 Build ID: 420m0(Build:2)

Example, in D2, E2, F2:

12,8 | DEBIT | VRAI [=SI(EXACT(E2;"DEBIT");D2;"")]

Interestingly, the result specified in the function wizard is correct...

Cheers, JPP

Why, in French, does the combo of functions SI(EXACT(cell1,text);cell2;cell3) returns a boolean instead of cell2 or cell3?

LibreOffice 4.2.8.2 Build ID: 420m0(Build:2)

Example, in D2, E2, F2:

12,8 | DEBIT | VRAI [=SI(EXACT(E2;"DEBIT");D2;"")]

Interestingly, the result specified in the function wizard is correct...

Cheers, JPP