formula

  • Thread starter Thread starter Fernando Duran
  • Start date Start date
F

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
 
Sorry, i forgot to post the formula...

=IF(OR(C8<>"NF",C8<>"NS",C8<>"NB"),"","HARMONY: ")
 
Can you explain, why the inverse doesn't work?
and thanks for the solution.

Fernando
 
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
 
Back
Top