can excel produce text in a given cell as a result of a boolean operation?
 

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

can excel produce text in a given cell as a result of a boolean operation?
 

Maybe this:

=IF(ISERROR(A1+0),A1,A1+0)

Biff

"Richard Erlacher" wrote in message
...
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

can excel produce text in a given cell as a result of a boolean operation?
 

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" wrote in message
...
Maybe this:

=IF(ISERROR(A1+0),A1,A1+0)

Biff

"Richard Erlacher" wrote in message
...
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

can excel produce text in a given cell as a result of a boolean operation?
 

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" wrote in message
...
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" wrote in message
...
Maybe this:

=IF(ISERROR(A1+0),A1,A1+0)

Biff

"Richard Erlacher" wrote in message
...
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

can excel produce text in a given cell as a result of a boolean operation?
 

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
Maybe this:

=IF(ISERROR(A1+0),A1,A1+0)

Biff

"Richard Erlacher" wrote in message
...
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

can excel produce text in a given cell as a result of a boolean operation?
 

Hmmm.....

Maybe this:

INDIRECT(A1)

Where A1=XYZ and XYZ refers to a named cell.

Biff

"Richard Erlacher" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
Maybe this:

=IF(ISERROR(A1+0),A1,A1+0)

Biff

"Richard Erlacher" wrote in message
...
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