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:


Thank you for any help!

1 Answer 1


Try this way:


enter image description here

enter image description here

  • I tried something similar to this, but unfortunately it still includes the second If when the first is met. I.e. all High percentages show as HighMedium. I just tried this... IF(D≥66.6%,"High","")&IF((D>33.3%)+(D<66.6%),"Medium","")&IF(D≤33.3%,"Low","") It works but it shows a blue triangle with "The formula uses a Boolean in place of a number." Nov 17, 2014 at 13:41
  • This way works. Check the images. The only way to put two (or more) IF statements in the same cell is when they are nested.
    – jherran
    Nov 17, 2014 at 13:46
  • Ah thanks jherran! I still had the & operator between Ifs, I've just realised :) It works perfectly, thank you! Nov 17, 2014 at 13:51

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .