Numbers: How to write between in an IF statement

numbers

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","")&IF(D>33.3%<66.6%,"Medium","")&IF(D≤33.3%,"Low","")

Thank you for any help!

Try this way:

IF(D≥66.6%,"High",IF(D<=33.3%,"Low","Medium"))

enter image description here

You are correct in that you need to use the SUMIF function. This is the specification from the Function Browser:

SUMIF(test-values, condition, sum-values)

Try this in your cell:

=SUMIF(CATEGORY; "=HW"; POINTS)

It works by dereferencing the value of a cell directly to the condition

Example:

SUMIFS(Daily Log::Income,Daily Log::A,">=2014-07-01",Daily Log::A,"<2014-08-01")

Referencing the cell could also be made possible with the same construct; by adding ampersand followed by the cell name outside the double quotes.

Example:

SUMIFS(Daily Log::Income,Daily Log::A,">="&A3,Daily Log::A,"<"&A4)