Hello,
I have a table D28:D1628 with values incrementing up to 5 decimal values.
In a different cell I generate a number that is not always identical to the values in the D28:D1628 column, therefore I need to approximate this value to the nearest one of the column.
Does anyone have an idea how to do this ?
Many many thanks in advance
I have a table D28:D1628 with values incrementing up to 5 decimal values.
In a different cell I generate a number that is not always identical to the values in the D28:D1628 column, therefore I need to approximate this value to the nearest one of the column.
Does anyone have an idea how to do this ?
Many many thanks in advance