[Libreoffice-bugs] [Bug 131469] New: Add an IFVALUE function to Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: director84 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200321/00e09c36/attachment.htm>