2

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!

1

Try this way:

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

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." – Lee Colarelli Nov 17 '14 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 '14 at 13:46
  • Ah thanks jherran! I still had the & operator between Ifs, I've just realised :) It works perfectly, thank you! – Lee Colarelli Nov 17 '14 at 13:51

You must log in to answer this question.

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