Well, just when you think it's safe to go in the water.....
I used this formula: =100-(COUNTIF(C8:AF8,"No")*10)
and thought it worked great but then discovered some people
used "N" for no and some typed out "No" for no.So it worked for
NO but not for N.
How do I make it work for
both?
I tried using "if" and "or" in there a couple of different ways, but I'm
doing
something wrong. Excel keeps yelling
at me :)