|I'm making a spreadsheet to track whether course prerequisites are being met by the recommended course sequence at the university where I work. What I am wondering is whether students can meet all their prerequisites if they take their courseload in the order we recommend.|
On my sheet, course numbers are listed in the order they must be taken down column C. Prerequisites for each of these courses are in column H. My nested IF statement currently looks like this:
=IF(OR($C$5 = H18, $C$8 = H18, $C$9=H18, $C$10=H18, $C$11=H18,$C$12=H18,$C$13=H18,$C$14=H18,$C$15=H18), "yes", "NO")
The idea is that the function will check each of the C cells for the prerequisite value in H. If the prereq. has been met, a "yes" will appear. If not, then a "no," and I will know to adjust the recommended course sequence accordingly.
The way it is now technically works. But is is possible to replace all the individual C cells I'm listing with a range, something like $C$5:$C$15? Because I have to maintain this sheet, it would be much easier to update it each semester if I could use ranges instead of having to type out each cell I'd like checked.
Is this possible??