Hello,

I'm trying not to use many cells to make a calculation, because it would be variable.

I have a cubic spline function, and will take N samples of the spline, and then average those N samples. N can be anything, even a large number. I'm thinking maybe I can do a for loop in a formula directly written into a cell (like if-then)? So, I need to calculate each value of N, let's say it goes from 0-1 in increments of 2.5% (could be any increment), then use N in the spline lookup, and save those samples??? ...and then calculate the average of all those samples. I know a VB script would work...that's plan B

Thanks for any suggestions.