Determine if a value in a range is close to the value of another c
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
|