On 05/15/2013 04:16 PM, Carl Paulsen wrote:
Anyone know if there is an equivalent to the Filemaker Pro "Case"
function? It's kinda like the "IF" function but is simpler to
concatenate multiple conditions. It basically says If something is
true then do what is specified, if the next thing is, then do that, if
the next thing is true, do that, etc.
I just checked the available functions in Calc. The "Case"
function does not appear among them. "Case When" is available in Base
database queries though.
Here's what I need to do. Take 4 columns and concatenate with a
semi-colon between the values, but not string together two semi-colons
Phone Email Mail -> Phone;Email;Mail
Phone Mail -> Phone;Mail
Mail -> Mail
Email Mail -> Email;Mail
So semi-colons only occur if there's a value present and not at all if
there's only one value present.
I hope that makes sense and displays correctly.
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy