|First off, are you aware that when you enclose a number in quotation marks it will be placed in the cell as Text, not as a number? |
Depending on what you are doing with the value that the IF function returns, that may or may not be a problem.
In any case, you should be aware that a "1" is not the same as a 1.
As far as "when I write DISQUALIFY it should show 0", you've already written a Nested IF that's 4 IF's deep so I would think that you would know how to add a 5th condition.
Just start your formula with...
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.