Nested If Formula With Multiple Conditions

[lprc]

Here is the file.

[Rick Rothstein]

Here is the file.

None of these formulas are working for me . , but thanks anyways.

I posted this formula earlier...

=IF(OR(COUNTIF(D2:F2,"<4"),G2<5),0,18+9*(G2>=7))

Please describe in what way it is not working for you.

Also, I notice you have the letter 'n' appearing at some locations within Columns D:F... how did you want the formula to handle them (being they are not numbers)... Ignore them? Treat them as if they were 0? Something else?