IF between Value Function

[Houscoogs]

I want to insert a (If(value >20%,"Great",Value between 0% and 20%,"Good", value between -20% and 0,"Bad") Can someone help with the syntax?

Thanks!

 

[richarddec]

If the percentages are in cell A1, you could use this. This will show nothing if the cell is blank as well. (Something I frequently add)

=IF(A1="","",IF(A1<0%,"Bad",IF(AND(A1>=0,A1<=20%),"Good","Great")))

 

[repairman615]

Hello,

<TABLE style="WIDTH: 554pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=738><COLGROUP><COL style="WIDTH: 554pt; mso-width-source: userset; mso-width-alt: 13494" width=738><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #c2d69a; WIDTH: 554pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20 width=738>=IF(B1>0.2,"Great",IF(AND(B1>=0,B1<=0.2),"Good",IF(AND(B1>=-0.2,B1<0),"bad","---")))</TD></TR></TBODY></TABLE>

 

[Aladin Akyurek]

I want to insert a (If(value >20%,"Great",Value between 0% and 20%,"Good", value between -20% and 0,"Bad") Can someone help with the syntax?

Thanks!

Try...

=IF(ISNUMBER(A2),
    IF(A2 > 20%, "Great",
      IF(AND(A2 > 0, <= 20%), "Good",
        IF(AND(A2 >= -20, <= 0), "Bad", "")))
    "")