Positive and Negative Symbol Display and "Pass"/"Fail" display with colors

[CSRUSS]

I have two separate questions:

1. I am trying to have the following formula display a “positive” (+0.00151) or “negative.”(-0.00151) symbol in the cell: =(F9-H9)*0.00001

2. I am trying to display the words “PASS” or “FAIL” (in cell N9) based on the following formula: IF L9 is GREATER than K9, then display “PASS”. IF L9 is LESS than K9, then display “FAIL”. (NOTE: If the word FAIL displays, then the font should be RED)

Greatly appreciate any guidance on the problems!

 

[bobsan42]

1. I am trying to have the following formula display a “positive” (+0.00151) or “negative.”(-0.00151) symbol in the cell: =(F9-H9)*0.00001

Use custom number formatting (Select the cell and press Ctrl+1) goto number tab > Custom Category> Type:

+ 0.00000;- 0.00000;0;@

if you don't need a fixed number of digits use # instead of 0

2. I am trying to display the words “PASS” or “FAIL” (in cell N9) based on the following formula: IF L9 is GREATER than K9, then display “PASS”. IF L9 is LESS than K9, then display “FAIL”. (NOTE: If the word FAIL displays, then the font should be RED)

The straight-forward way is to write a formula to display the texts, then use Conditional formatting to colorize it:

=IF(L9>K9,"PASS",IF(L9<K9,"FAIL","-"))

Create a new rule and press Format ... and choose whatever you like:

 

[Joe4]

1. I am trying to have the following formula display a “positive” (+0.00151) or “negative.”(-0.00151) symbol in the cell: =(F9-H9)*0.00001

Use the following Custom format:

(+General);(-General)

2. I am trying to display the words “PASS” or “FAIL” (in cell N9) based on the following formula: IF L9 is GREATER than K9, then display “PASS”. IF L9 is LESS than K9, then display “FAIL”. (NOTE: If the word FAIL displays, then the font should be RED)

Use the following formula:

=IF(L9>K9,"PASS",IF(L9<K9,"FAIL","EQUAL"))

(note that you did not mention what you want returned if they were equal)

To make word "FAIL" red, simply apply Conditional Formatting on cell N9 with the formula:

=N9="FAIL"

and choose the red formatting color.

 

[CSRUSS]

Use the following Custom format:

(+General);(-General)

Use the following formula:

=IF(L9>K9,"PASS",IF(L9<K9,"FAIL","EQUAL"))

(note that you did not mention what you want returned if they were equal)

To make word "FAIL" red, simply apply Conditional Formatting on cell N9 with the formula:

=N9="FAIL"

and choose the red formatting color.

Thank you so much! This was the perfect solution!!! Thanks for being so responsive!

 

[Joe4]

You are welcome.
Glad we were able to help!