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