Closest Value

[dhen21dx]

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

Value	Lower	Higher	Result
5	7	11	7
7	9	13	9
4	5	9	4
15	17	21	17
32	23	27	27

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[alpadem]

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
A B C D

Value	Lower	Higher	Result
5	7	11	7
7	9	13	9
4	5	9	4
15	17	21	17
32	23	27	27

<tbody>
</tbody>

In the D2 cell you should write =IF(ABS(C2-A2)>ABS(D2-A2),D2,C2)

 

[alpadem]

Sorry correction------->In the D2 cell you should write =IF(ABS(B2-A2)>ABS(C2-A2),C2,B2)

 

[dhen21dx]

Thank you, this really help.