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?
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?