How to find the a value closest to a given value

Hi Sir,

I have a question about how to find a value which is the closest to a give value. For example,

if the given value is 0.1, and the list of available values are: 0.0, 0.3, 0.5, then the closest value is 0.0 (NOT 0.3).

In another case,

if the given value is 2, and the list of available values are 0, 3, 4, then the closest value is 3.

Not sure which look up function to use.

Thanks in advance

Here, try this

comfirmed with ctrl+shift+enter (not just enter)

Formula:

Please Login or Register  to view this content.

Assuming C2 is criteria and C3:C5 is data

Originally Posted by zbor

Here, try this

comfirmed with ctrl+shift+enter (not just enter)

Formula:

Please Login or Register  to view this content.

Assuming C2 is criteria and C3:C5 is data

Thanks, zbor. It worked perfectly