Numbers: How do I write between in an IF statement? I can't get the following formula to work in Apple's Numbers.app. I need the second IF to be BETWEEN 33.3% AND 66.6%.

This is what I have tried but it does not work:

IF(D≥66.6%,"High","")&amp;IF(D&gt;33.3%&lt;66.6%,"Medium","")&amp;IF(D≤33.3%,"Low","")


Thank you for any help!
Try this way:

IF(D≥66.6%,"High",IF(D&lt;=33.3%,"Low","Medium"))