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