View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Erlacher Richard Erlacher is offline
external usenet poster
 
Posts: 3
Default 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