Hi :)
WoooHooo!! Nicely done! :) Is this whole thread solved now? COngrats of so!
Regards from
Tom :)
From: Carl Paulsen carlpaul...@comcast.net
To: users@global.libreoffice.org
Sent: Thursday, 16 May 2013, 1:44
Subject: Re: [libreoffice-users] Case
:)
*From:* Carl Paulsen carlpaul...@comcast.net
*To:* users@global.libreoffice.org
*Sent:* Thursday, 16 May 2013, 1:44
*Subject:* Re: [libreoffice-users] Case function equivalent in Calc
At long last I got this to work
*To:* users@global.libreoffice.org
*Sent:* Thursday, 16 May 2013, 1:44
*Subject:* Re: [libreoffice-users] Case function equivalent in Calc
At long last I got this to work. Syntax is ISBLANK and not
ISEMPTY
- aaa. My Filemaker days are getting in my way
*Sent:* Thursday, 16 May 2013, 1:44
*Subject:* Re: [libreoffice-users] Case function equivalent in
Calc
At long last I got this to work. Syntax is ISBLANK and not
ISEMPTY
- aaa. My Filemaker days are getting in my way.
Replace
all isempty below with ISBLANK
:)
--
--
*From:* Carl Paulsen carlpaul...@comcast.net
*To:* users@global.libreoffice.org
*Sent:* Thursday, 16 May 2013, 1:44
*Subject:* Re: [libreoffice-users] Case function equivalent in Calc
At long last I got this to work. Syntax is ISBLANK
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
Another way to state this is I'd like a Columns to Text function, but
where I can specify semi-colon as the separator and it won't place two
separators together consecutively.
Thanks again,
Carl
On 5/15/13 4:16 PM, Carl Paulsen wrote:
Anyone know if there is an equivalent to the Filemaker
All I've ever been aware of is nested IF statements, which get to be a
royal pain. If there is a CASE equivalent (it's also present in just
about any programming language), I'll be just as happy as you!
Dave
On 5/15/2013 13:16, Carl Paulsen wrote:
Anyone know if there is an equivalent to
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,
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
At long last I got this to work. Syntax is ISBLANK and not ISEMPTY
- aaa. My Filemaker days are getting in my way. Replace
all isempty below with ISBLANK and it works perfectly now.
Carl
On 5/15/13 6:38 PM, Carl Paulsen wrote:
So in the absence of a Case function, here's what
11 matches
Mail list logo