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

So in the absence of a Case function, here's what I've done so far as a 
calculated solution.  Note that the data I want to concatenate is in 
cells U3, V3, W3, and X3.  In Y3, I put the following:

=U3 & IF(NOT(isempty(U3)),";","") & V3 & IF(NOT(isempty(V3)),";","") & 
W3 & IF(NOT(isempty(W3)),";","") & X3

The idea is that I put together U3, a semicolon if U3 isn't empty (and 
nothing if it is), V3 and a semicolon if V3 isn't empty, W3 and a 
semicolon if W3 isn't empty, and X3.  If any of the cells is empty, 
nothing will be added until the next cell that has data.

Unfortunately, I'm getting a #NAME? error.  I'm assuming some kind of 
syntax error.  Any words of wisdom?

Thanks a ton all.
Carl



On 5/15/13 5:13 PM, Dan Lewis wrote:
> 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