Excel: Formula for closest number


Hello everybody I need a formula in D2 that find th closest number (criteria number in D1) esemple if in D1 is 9 should give me back 11 but if in D2 i digit 5 it should give me 4 thank yu for your help

ABCD
11CRITERIA6
24RESULT5
35
49
511
615
718
819

Foglio1




This question generated 31 answers. To proceed to the answers, click here.

This thread is current as of April 06, 2015.


For more resources for Microsoft Excel