Hello, I am trying to find the minimum distance between a series of data points and a function. I know how to do it symbolically, plug the formula into the distance formula, take the derivative and set to zero to find the minimum and plug into the distance formula, but I am having a hard time figuring out how to do this in excel. One method I can think of is to calculate the distances from the point to the surrounding points on the function and take the minimum. However this would require about 40 distance per data point and I have 8000 data points. Is there a way to do this in one step, and I would prefer not to use macros. Or if you have alternate suggestions I am completely open.