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?[TABLE="width: 201"]
<colgroup><col></colgroup><tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Point[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]84-84.9[/TD]
[TD]80%[/TD]
[/TR]
[TR]
[TD]83-83.9[/TD]
[TD]60%[/TD]
[/TR]
[TR]
[TD]82-82.9[/TD]
[TD]40%[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Below 82[/TD]
[TD]0 [/TD]
[/TR]
</tbody>[/TABLE]

 

[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.