i am using the below lookup formula but it the value less than 0 it give error
=LOOKUP(F3,{0,80,90,110,150},{"Excellent","Good","Average","Below Average","Poor"})
<colgroup><col><col></colgroup><tbody>
</tbody>
=LOOKUP(F3,{0,80,90,110,150},{"Excellent","Good","Average","Below Average","Poor"})
-1 | #N/A |
44 | Excellent |
88 | Good |
90 | Average |
110 | Below Average |
155 | Poor |
<colgroup><col><col></colgroup><tbody>
</tbody>