I have a dynamic list of values in an excel worksheet. I need to find a way to identify the lowest number in the array that is closest to a whole number. example: in one instance the list includes the following numbers: 1.56, 1.65, 1.71, 1.84, 1.94, 2.00, 2.06, 2.03, 2.22........2.95, 3.05, 3.81, 4.00 etc. the number I want to find in this instance is 2.00. Is there a function in Excel that I can use for this?
See Question&Answers more detail:os