IF

[kelvin0403]

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>

Point	Result
84-84.9	80%
83-83.9	60%
82-82.9	40%

<tbody>
</tbody>

Below 82

0

<tbody>
</tbody>

 

[DanteAmor]

Try:

=IF(A3<82,0,IF(A3<=82.9,0.4,IF(A3<=83.9,0.6,0.8)))

 

[kelvin0403]

Thanks Dante

 

[DanteAmor]

Youre welcome.