Hi Raven

try to use lookup, assuming that the average formula is on the a40 and the
range is on A2 thu A35 so:

=llokup(a40,a2:a35)

the function will return the closer number of the range

hope this helps
Regards from Brazil
Marcelo

"Raven" escreveu:

Hi!

Is there a way to determine if there is a number in a range of values that
is closest in value to another number? I have a column of numbers that I
have used to calculate an average, but now I want to find out which of those
numbers is closest to the average.

Thanks!
--
Ray