Compare cell to 3 values

[jjcaprio]

Preferences


So I am trying to type teams based on an average number the team produces as Type I, II or III. An example would be The average RN's a team rosters is 6, so to be a type I team you need 8, Type II 6 and type II is 4.

Number Type III Type II Type I Team is a
RN 6 4 6 8 Type II
MD 2 2 3 4 Type I

Looking for a formula to list the type value by comparing the number against the 3 types of teams and returning either Type I, II or III and having the cell change color to Red for type I, Yellow for Type II and Green for type III

Position	Rosters 2011 to Present	Position Type	TYPE III	TYPE II	TYPE I
AO	1.00		0	1	1
COMM-L	1.00		1	1	2
DTL	1.00		0	0	1
EMT-P	11.00		4	6	8
LOGS	1.00		0	2	4
MD/DO	2.80		2	2	2
MH	1.29		0	1	1
MIDLEVEL	2.86		1	3	4
PHARM	2.13		1	2	2
RN	8.88		4	6	8
SAFETY	1.14		1	1	1
TL	1.00		1	1	1

<tbody>
</tbody>

Thanks
Preferences

<canvas class="button_canvas" width="32" height="32">§</canvas>
<canvas class="button_canvas" width="32" height="32">1</canvas>
<canvas class="button_canvas" width="32" height="32">2</canvas>
<canvas class="button_canvas" width="32" height="32">3</canvas>
<canvas class="button_canvas" width="32" height="32">4</canvas>
<canvas class="button_canvas" width="32" height="32">5</canvas>
<canvas class="button_canvas" width="32" height="32">6</canvas>
<canvas class="button_canvas" width="32" height="32">7</canvas>
<canvas class="button_canvas" width="32" height="32">8</canvas>
<canvas class="button_canvas" width="32" height="32">9</canvas>
<canvas class="button_canvas" width="32" height="32">0</canvas>
<canvas class="button_canvas" width="32" height="32">-</canvas>
<canvas class="button_canvas" width="32" height="32">=</canvas>
<canvas class="system_button_canvas" width="100" height="32">Backspace</canvas>

<canvas class="system_button_canvas" width="32" height="32">Tab</canvas>
<canvas class="button_canvas" width="32" height="32">q</canvas>
<canvas class="button_canvas" width="32" height="32">w</canvas>
<canvas class="button_canvas" width="32" height="32">e</canvas>
<canvas class="button_canvas" width="32" height="32">r</canvas>
<canvas class="button_canvas" width="32" height="32">t</canvas>
<canvas class="button_canvas" width="32" height="32">y</canvas>
<canvas class="button_canvas" width="32" height="32">u</canvas>
<canvas class="button_canvas" width="32" height="32">i</canvas>
<canvas class="button_canvas" width="32" height="32">o</canvas>
<canvas class="button_canvas" width="32" height="32">p</canvas>
<canvas class="button_canvas" width="32" height="32">[</canvas>
<canvas class="button_canvas" width="32" height="32">]</canvas>

<canvas class="system_button_canvas" width="100" height="50">Return</canvas>



<canvas class="system_button_canvas" width="32" height="32">capslock</canvas>
<canvas class="button_canvas" width="32" height="32">a</canvas>
<canvas class="button_canvas" width="32" height="32">s</canvas>
<canvas class="button_canvas" width="32" height="32">d</canvas>
<canvas class="button_canvas" width="32" height="32">f</canvas>
<canvas class="button_canvas" width="32" height="32">g</canvas>
<canvas class="button_canvas" width="32" height="32">h</canvas>
<canvas class="button_canvas" width="32" height="32">j</canvas>
<canvas class="button_canvas" width="32" height="32">k</canvas>
<canvas class="button_canvas" width="32" height="32">l</canvas>
<canvas class="button_canvas" width="32" height="32">;</canvas>
<canvas class="button_canvas" width="32" height="32">'</canvas>
<canvas class="button_canvas" width="32" height="32">\</canvas>

<canvas class="system_button_canvas" width="32" height="32">shift</canvas>
<canvas class="button_canvas" width="32" height="32">`</canvas>
<canvas class="button_canvas" width="32" height="32">z</canvas>
<canvas class="button_canvas" width="32" height="32">x</canvas>
<canvas class="button_canvas" width="32" height="32">c</canvas>
<canvas class="button_canvas" width="32" height="32">v</canvas>
<canvas class="button_canvas" width="32" height="32">b</canvas>
<canvas class="button_canvas" width="32" height="32">n</canvas>
<canvas class="button_canvas" width="32" height="32">m</canvas>
<canvas class="button_canvas" width="32" height="32">,</canvas>
<canvas class="button_canvas" width="32" height="32">.</canvas>
<canvas class="button_canvas" width="32" height="32">/</canvas>
<canvas class="system_button_canvas" width="32" height="32">shift</canvas>


English


Deutsch


Español


Français


Italiano


Português


Русский




<canvas class="button_canvas" width="32" height="32">alt</canvas>
<canvas class="button_canvas" width="32" height="32"> </canvas>
<canvas class="button_canvas" width="32" height="32">alt</canvas>





Preferences