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.
Return closest numeric match
{ 2 Comments }