Nested IF statements using AND

[heikemarie]

Hi all! I'm fairly new to the Excel game and I haven't been running into many problems -- when I do, a quick look through Google or Reddit has pretty much been able to solve my issues. I'm hoping you can help with my latest frustration!

I'm running Excel 2011 on Mac.

I'm creating a spreadsheet to track my students' reading assessment data. I've created an aggregate column that I essentially want to note if a student passed the assessment or not. If they fail any part of the test, they fail the assessment and the "Passed?" column says "NO".

 =IF(B4<4,"NO",IF(E4<15,"NO",IF(G4<6,"NO",IF(K4<5,"NO"))))

That part if working fine. I've also used conditional formatting so that if the text says "NO" the cell turns red. No problem there.

However, I'm trying to use a nested IF with AND to say that if ALL the sections have been passed with a certain score, then the column should display "YES". This is what I have attempted to use to do that:

=IF(AND(B4>3, E4>14, G4>5, K4>4,"YES"))

However, I keep getting "THe formula you typed contains an error." Is there a way to get the Nested IF using AND to function for this cell? Or, perhaps there's an easier way to code that if the cell doesn't say "NO," then it will say "YES"?

Sorry if I sound foolish! I'm trying to get this finished before the school year starts so my approach to learning Excel has been really ad hoc. I'm looking forward to taking a less crazy approach so I don't feel like such an idiot!

Thanks for all of your help,
Heike

 

[AlphaFrog]

Try something like this...

=IF(AND(B4>3, E4>14, G4>5, K4>4),"YES", "NO")