Hi,
Please help me, i need to get the closest number from the value from the Lower/Higher column. Let say value 5, the closest is the Lower number which is 7.
Thanks
[TABLE="width: 200"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Value[/TD]
[TD]Lower[/TD]
[TD]Higher[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD="align: right"]32[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]27[/TD]
[/TR]
</tbody>[/TABLE]
Please help me, i need to get the closest number from the value from the Lower/Higher column. Let say value 5, the closest is the Lower number which is 7.
Thanks
[TABLE="width: 200"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Value[/TD]
[TD]Lower[/TD]
[TD]Higher[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD="align: right"]32[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]27[/TD]
[/TR]
</tbody>[/TABLE]