Another question about IF(COUNTIF) checks in Excel

G

Guest

Oh, one more question. This is rediculously complicated, I know, but... when
you use the IF(COUNTIF) formula, can you put another IF(COUNTIF) check in
the "value if false" spot? Because if there isn't an "S" in the column, it
needs to be able to check for a "P" or an "N" (independent study or not
enrolled) and mark
that instead.

I've been trying to figure it out with the =OR formula but I keep getting
errors. This is what I've been typing that's not working and I don't know why:

=OR(IF(COUNTIF(AA8:AA10,"S"),"S",(IF(COUNTIF(AA8:AA10,"P"),"P","A"))))

Any ideas?
 
D

Dave Peterson

Maybe...

=IF(COUNTIF(AA8:AA10,"S"),"S",IF(COUNTIF(AA8:AA10,"P"),"P","A"))

would do what you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top