formula

[Fernando Duran]

I have this formula, i'm trying to write Harmony, when equal to NF, NS & NB,
and clear in the other case.. where I'm failing?

Thanks

 

[Fernando Duran]

Sorry, i forgot to post the formula...

=IF(OR(C8<>"NF",C8<>"NS",C8<>"NB"),"","HARMONY: ")

 

[CLR]

=IF(OR(C8="NF",C8="NS",C8="NB"),"HARMONY: ","")

Vaya con Dios,
Chuck, CABGx3

 

[Fernando Duran]

Can you explain, why the inverse doesn't work?
and thanks for the solution.

Fernando

 

[CLR]

You're welcome, and Sorry, I can not explain...........

Vaya con Dios,
Chuck, CABGx3

 

[Frank Kabel]

Hi Fernando
the IF function has the following syntax
=IF(condition,True part, False part).
That is if the condition is met the True part is evaluated/'executed'.
If the condition is not met, the third parameter (the 'False' part) is
evaluated.
So your 'reverse' formula
=IF(OR(C8<>"NF",C8<>"NS",C8<>"NB"),"","HARMONY: ")

does the following: It will print "HARMONY:" if C8 is neither "NF",
"NS","NB". e.g. if you would enter "XX" in cell C8 the condition is not
met and the third parameter is printed