kelvin0403
Board Regular
- Joined
- Jul 25, 2011
- Messages
- 51
Hi,
I would like to set a formula to return the result as below if the target cell fall to these range. How the formula should set?
<colgroup><col></colgroup><tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
I would like to set a formula to return the result as below if the target cell fall to these range. How the formula should set?
<colgroup><col></colgroup><tbody>
</tbody>
Point | Result |
84-84.9 | 80% |
83-83.9 | 60% |
82-82.9 | 40% |
<tbody>
</tbody>
Below 82 | 0 |
<tbody>
</tbody>