if statement

[gledister]

we have a colums of values from 10 to 150, example:

12
34
67
78
90
92
95
99
102
105
110
120
122
133

In a column nearby we want to say:
all values less than 80 are "Disapproved", from 80 to 110 they are "OK", from 110 to infinite they are "GREAT".

Anyone as any idea?

 

[Snailspace]

Maybe,

<b>Excel 2003</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;">12</td><td style=";">Disaproved</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">34</td><td style=";">Disaproved</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">67</td><td style=";">Disaproved</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">78</td><td style=";">Disaproved</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">90</td><td style=";">OK</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">92</td><td style=";">OK</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">95</td><td style=";">OK</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">99</td><td style=";">OK</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">102</td><td style=";">OK</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">105</td><td style=";">OK</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">110</td><td style=";">OK</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">120</td><td style=";">GREAT</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;">122</td><td style=";">GREAT</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;">133</td><td style=";">GREAT</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;">80</td><td style=";">OK</td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;">110</td><td style=";">OK</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B1</th><td style="text-align:left">=IF(<font color="Blue">A1<80,"Disaproved",IF(<font color="Red">A1>110,"GREAT","OK"</font>)</font>)</td></tr></tbody></table></td></tr></table><br />

 

[Peter_SSs]

Depend just where an exact value of 110 should fit, but this may also be worth considering. It's advantage is if you wanted to expand the number of possible responses it's easy to keep adding values to the two arrays. (The first array needs to be in ascending order.)

=LOOKUP(A1,{10,80,110},{"Disapproved","OK","GREAT"})

 

[gledister]

They both work, thank you very much.

Peter your version is awesome!

 

[Peter_SSs]

Peter your version is awesome!

Thanks, but note that I was not suggesting anything at all wrong with the formula suggested by Snailspace, it does the job you asked, perfectly well.

 

[gledister]

I know

Yours is just better for more complexed situations and thats cool

Thanks a lot!