Return closest numeric match

{ 2 Comments }

In range A2:A6, the numbers are 7.5, 2, -12, 11.2 and 8.  In cell B8, a user enters 8.  One may want to answer the following questions:

1. Return the closest number which is less than or equal to the number in cell B8
2. Return the closest number which is greater than or equal to the number in cell B8
3. Return the closest match

You may refer to my solution in this workbook.

Leave a Comment Cancel reply

Your email address will not be published.

*