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
|