EXCEL - using multiple IF AND statements. Where have I gone wrong?

I have a basic understanding of excel formulas work and have used this site many times to broaden my knowledge, however, I'm stuck on the below and I'm hoping someone can assist me.

I'm trying to create a formula to work out if a KPI has been met. I have 3 separate formulas that I need to combine into one.

=IF(AND(E2="1",S2>0.041667),"YES","NO")
=IF(AND(E2="2",S2>0.125),"YES","NO")
=IF(AND(E2="3",S2>0.25),"YES","NO")

How do I do this?