Nested If Formula With Multiple Conditions

**lprc** · 04-22-2013, 01:14 PM

None of these formulas are working for me .

, but thanks anyways.

**LalitPandey87** · 04-22-2013, 01:26 PM

Formula given by me and by experts are based on what you have asked.
If it is not working then why don't share your file for better clearity.

**lprc** · 04-22-2013, 05:04 PM

Here is the file.

**Rick Rothstein** · 04-22-2013, 07:27 PM

Originally Posted by lprc

Here is the file.

Originally Posted by lprc

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?