Nesting "or" functions within an "if" function
I am creating a grading spreadsheet. I have 2 sheets within the spreadsheet, one with variables that register points possible and minimum acceptable points on 8 different criteria. I am trying to create a cell that will say "passed" if all criteria is met and "failed" if not. The "E" column has the grade and the Variables!D# is the minimum allowable. Here is the formula that I am trying to create to accomplish this:
=IF(E22<Variables!D9+OR(E21<Variables!D8)+OR(E20<Variables!D7)+OR(E19<Variables!D6)+OR(E18<Variables!D5)+OR(E17<Variables!D4)+OR(E16<Variables!D3)+OR(E15<Variables!D2),"Failed","Passed")
And I am sure there is an easier way but the spreadsheet accepts the formula but always reads "Passed".
Thanks in advance for any help you can offer.
MacBook Pro, iOS 8.1.2