Most valuable professional
  • Hot Topics

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 1 2 3 4 5 6 7 8 Foglio1

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

This thread is current as of April 6, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel