I want column 4 to return the stars based on where the data falls in the table. I consider myself pretty good with excel but this one has me stumped. I though and if function couldn't figure that one out. Here is the Data
Thanks!
Was going to attach table but it says I cant... here is images.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Facility[/TD]
[TD]RNs[/TD]
[TD]Total Nursing[/TD]
[TD]Stars[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD].531[/TD]
[TD]4.028[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD].335[/TD]
[TD]3.606[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD].758[/TD]
[TD]3.703[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1.255[/TD]
[TD]6.075[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD].761[/TD]
[TD]3.504[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Here is how the stars lies (in my spreadsheet I have pics of stars using wingdings symbol)
....................................................................................Total Nursing
[TABLE="width: 500"]
<tbody>[TR]
[TD]RN[/TD]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]<3.176[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]3.176-3.551[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]3.552-4.009[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]4.010-4.237[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]>=4.238[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]<0.246[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]*[/TD]
[TD="align: center"]*[/TD]
[TD="align: center"]**[/TD]
[TD="align: center"]**[/TD]
[TD="align: center"]***[/TD]
[/TR]
[TR]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]0.246-0.382[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]*[/TD]
[TD="align: center"]**[/TD]
[TD="align: center"]***[/TD]
[TD="align: center"]***[/TD]
[TD="align: center"]***[/TD]
[/TR]
[TR]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]0.383-0.586[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]**[/TD]
[TD="align: center"]***[/TD]
[TD="align: center"]***[/TD]
[TD="align: center"]****[/TD]
[TD="align: center"]****[/TD]
[/TR]
[TR]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]0.587-0.883[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]**[/TD]
[TD="align: center"]***[/TD]
[TD="align: center"]****[/TD]
[TD="align: center"]****[/TD]
[TD="align: center"]****[/TD]
[/TR]
[TR]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]>=0.884[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]***[/TD]
[TD="align: center"]***[/TD]
[TD="align: center"]****[/TD]
[TD="align: center"]****[/TD]
[TD="align: center"]*****[/TD]
[/TR]
</tbody>[/TABLE]
Thanks!
Was going to attach table but it says I cant... here is images.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Facility[/TD]
[TD]RNs[/TD]
[TD]Total Nursing[/TD]
[TD]Stars[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD].531[/TD]
[TD]4.028[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD].335[/TD]
[TD]3.606[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD].758[/TD]
[TD]3.703[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1.255[/TD]
[TD]6.075[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD].761[/TD]
[TD]3.504[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Here is how the stars lies (in my spreadsheet I have pics of stars using wingdings symbol)
....................................................................................Total Nursing
[TABLE="width: 500"]
<tbody>[TR]
[TD]RN[/TD]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]<3.176[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]3.176-3.551[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]3.552-4.009[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]4.010-4.237[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]>=4.238[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]<0.246[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]*[/TD]
[TD="align: center"]*[/TD]
[TD="align: center"]**[/TD]
[TD="align: center"]**[/TD]
[TD="align: center"]***[/TD]
[/TR]
[TR]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]0.246-0.382[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]*[/TD]
[TD="align: center"]**[/TD]
[TD="align: center"]***[/TD]
[TD="align: center"]***[/TD]
[TD="align: center"]***[/TD]
[/TR]
[TR]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]0.383-0.586[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]**[/TD]
[TD="align: center"]***[/TD]
[TD="align: center"]***[/TD]
[TD="align: center"]****[/TD]
[TD="align: center"]****[/TD]
[/TR]
[TR]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]0.587-0.883[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]**[/TD]
[TD="align: center"]***[/TD]
[TD="align: center"]****[/TD]
[TD="align: center"]****[/TD]
[TD="align: center"]****[/TD]
[/TR]
[TR]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111"]>=0.884[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]***[/TD]
[TD="align: center"]***[/TD]
[TD="align: center"]****[/TD]
[TD="align: center"]****[/TD]
[TD="align: center"]*****[/TD]
[/TR]
</tbody>[/TABLE]