Bug 143177 - Convierte ; en ~
Summary: Convierte ; en ~
Status: CLOSED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-07-03 23:01 UTC by Pascual Soprano
Modified: 2021-07-04 00:04 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Pascual Soprano 2021-07-03 23:01:23 UTC 
Yo escribo
=SI(Y(D4>0;F4<(BUSCARV(B4;$Inventario.B$2:$Inventario.H$1503;7;0);1;2)))
Calc convierte a
=SI(Y(D4>0;F4<(BUSCARV(B4;$Inventario.B$2:$Inventario.H$1503;7;0)~1~2)))
Comment 1 Eike Rathke 2021-07-04 00:04:44 UTC 
Your parentheses are misplaced, it probably should be

=SI(Y(D4>0;F4<BUSCARV(B4;$Inventario.B$2:$Inventario.H$1503;7;0));1;2)