Good Morning:
I am trying to utilize the following If And formula but it doesn't seem to be working.
=IF(AND(O8>="95",<="100","25",IF(AND(08>="85",<="94","20",IF(AND(O8>="70",<="84","15",IF(AND(O8>="50",<="69","10",IF(AND(O8>="30",<="49","5",IF(O<="29","0","null")))))))))))
I am trying to display a set value of points for a score with a range.
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
How can I fix this?
I am trying to utilize the following If And formula but it doesn't seem to be working.
=IF(AND(O8>="95",<="100","25",IF(AND(08>="85",<="94","20",IF(AND(O8>="70",<="84","15",IF(AND(O8>="50",<="69","10",IF(AND(O8>="30",<="49","5",IF(O<="29","0","null")))))))))))
I am trying to display a set value of points for a score with a range.
Score Range | = | | # of Pts | |
95to100% 85to94% 70to84% 50to69% 30to49% <=29% | 25 20 15 10 5 0 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
How can I fix this?