https://bugs.documentfoundation.org/show_bug.cgi?id=131469
Bug ID: 131469
Summary: Add an IFVALUE function to Calc
Product: LibreOffice
Version: 6.4.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: directo...@gmx.de
Imagine the following situation: You have a cell in column A which contains a
value in dependence of which you want to set the value of a cell in columb B.
Expamle: Cell B4 depends on A1.
Cell A1 Cell B4
1 A
13 B
27 C
65 D
77 E
Normally you would have to do something like this in the formula of cell B4:
= IF (A1=1;"A" ; IF (A1=13;"B"; IF (A1=27;"C"; IF (A1=65;"D"; IF (A1=77;"E" ;
"" )))))
That's why I suggest to add a new function "IFVALUE", or "WENNWERT" in the
German localization.
The usage would be like this:
= IFVALUE (referenced cell ; IF-value1;THEN-value1 ; IF-value2;THEN-value2 ;
IF-value3;THEN-value3 ; ELSE-value)
So the above example could be shortened like this:
= IFVALUE (A1 ; 1;"A"; 13;"B"; 27;"C"; 65;"D"; 77;"E"; "")
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs