How do you combine nested IF statements with multiple outcomes in Excel?

AU-contains numbers from 0-20 AV-needs to have high, moderate, low; based on the number in AU

=>5 HIGH 3-4 MODERATE <3 LOW开发者_运维问答

Wrote this below, however I get #NAME? for the answer; so I know some part of it is wrong. Please help.

=IF(OR(AU>=5),"High",IF(OR(AU<=4.9>=3),"Moderate",IF(OR(AU<3),"Low")))

---

Try this:

=IF(AU<3,"Low",IF(AU<5,"Moderate","High"))