Re: [libreoffice-users] "Case" function equivalent in Calc

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.
>
> 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 
> consecutively.  Like:
>
> 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.
>
> Carl
     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.

--Dan

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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