True / False to Pass / Fail

[12 string]

Using IF, I have created a formula that gives me a true or false reading in a cell. I would rather have the word Pass or Fail apear in the cell. :?)

 

[Mark O'Brien]

Let's so your IF formula then.

Without seeing it, I would say that you have the words "TRUE" and "FALSE" in the formula. I would just change these to "Pass" and "Fail" if that was the case, but I figure that it's a bit more complicated than that.

 

[Mark W.]

On 2002-04-18 06:55, 12 string wrote:
Using IF, I have created a formula that gives me a true or false reading in a cell. I would rather have the word Pass or Fail apear in the cell. :?)

=IF(<your formula>,"Pass","Fail")


Or...

=(<your formula>)+0

...and format the cell as...

[=1]"Pass";[=0]"Fail"
This message was edited by Mark W. on 2002-04-18 07:01
This message was edited by Mark W. on 2002-04-18 07:02