Re: can excel produce text in a given cell as a result of a boolean operation?
- From: "Biff" <biffinpitt@xxxxxxxxxxx>
- Date: Thu, 26 Oct 2006 16:39:35 -0400
Hmmm.....
Maybe this:
INDIRECT(A1)
Where A1=XYZ and XYZ refers to a named cell.
Biff
"Richard Erlacher" <richard_no_spam_4_me@xxxxxxxxxx> wrote in message
news:Oi0e6tM%23GHA.3456@xxxxxxxxxxxxxxxxxxxxxxx
I have a table of numeric values, either 1 or 0, and a segment of that
table, where, by means of 'IF' commands, I've converted those values to
booleans, though that may not be necessary. I have a number of cells, the
content of which is, in each case, a boolean function of either one of
those boolean independent variables, or a named (text) value defined
outside this system. Those dependent values can take on the value of a
boolean function of one or more of the booleans, or one of the named
inedpendent variables. I'm just uncertian of how to get excel to display
the result.
In fact, I think I've managed to get it working as I need, with the
exception that I would prefer not to have to assign the named independent
values to a separate cell in the table. I'd prefer to use the text name
in the formula that defines the dependent cell. Excel clearly doesn't
like me to use 'XYZ in a formula, as in one of the result options in an
'IF" function.
Richard
"Biff" <biffinpitt@xxxxxxxxxxx> wrote in message
news:u1KASHI%23GHA.4800@xxxxxxxxxxxxxxxxxxxxxxx
I think you need to explain more clearly what you're trying to do.
The way I read your post is:
"I have a table of either booleans or text and I want to convert the
booleans to numeric values and leave the text as text."
Based on your respone I did not understand what you want.
Biff
"Richard Erlacher" <richard_no_spam_4_me@xxxxxxxxxx> wrote in message
news:OwgHV%23H%23GHA.3860@xxxxxxxxxxxxxxxxxxxxxxx
I don't get it ...
I understand that <ISERROR> represents any boolean expression.
I belive I understand the format of the IF.
The numeric values in my table are either 1 or 0, which is easily
translated to TRUE or FALSE if necessary. (is it necessary?)
I express the logical values as, for example, (OR(not(E33),not(F33))
which I can then use in =IF((OR(not(E33),not(F33)),A33,C33), where A33
is my 'XYZ text value and C33 is, for example, IF(E33,1,0).
Does excel interpret A1+0 as A1 OR 0?
Richard
"Biff" <biffinpitt@xxxxxxxxxxx> wrote in message
news:OvKFkmH%23GHA.896@xxxxxxxxxxxxxxxxxxxxxxx
Maybe this:
=IF(ISERROR(A1+0),A1,A1+0)
Biff
"Richard Erlacher" <richard_no_spam_4_me@xxxxxxxxxx> wrote in message
news:%23trfSgH%23GHA.3456@xxxxxxxxxxxxxxxxxxxxxxx
I have a table consisting of a number of values, either TRUE, FALSE, or
a text value, e.g. 'XYZ, and I want to perform an IF operation on a
combination of OR's and AND's resulting in either 1, 0, or 'XYZ.
How can I force excel to do that?
thanx,
Richard
.
- References:
- can excel produce text in a given cell as a result of a boolean operation?
- From: Richard Erlacher
- Re: can excel produce text in a given cell as a result of a boolean operation?
- From: Biff
- Re: can excel produce text in a given cell as a result of a boolean operation?
- From: Richard Erlacher
- Re: can excel produce text in a given cell as a result of a boolean operation?
- From: Biff
- Re: can excel produce text in a given cell as a result of a boolean operation?
- From: Richard Erlacher
- can excel produce text in a given cell as a result of a boolean operation?
- Prev by Date: Re: #VALUE! - urgent
- Next by Date: Re: #ARG! - urgent
- Previous by thread: Re: can excel produce text in a given cell as a result of a boolean operation?
- Next by thread: Re: 2006 increments to 2007 Automatically
- Index(es):
Relevant Pages
|
