True / False to Pass / Fail

12 string · Apr 18th, 2002, 07:55 AM

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 · Apr 18th, 2002, 07:57 AM

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. · Apr 18th, 2002, 08:00 AM

Quote:

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(,"Pass","Fail")

Or...

=()+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 ]

Apr 18th, 2002, 07:57 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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 O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 07:55 AM	#1
12 string New Member Join Date: Apr 2002 Posts: 1	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. :?)