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

[Richard Erlacher]

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

 

[Biff]

Maybe this:

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

Biff

 

[Richard Erlacher]

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]

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]

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]

Hmmm.....

Maybe this:

INDIRECT(A1)

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

Biff