Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to know how I can programmatic use my linear interpolate equation without having the user or myself to use the Goal Seek function in the data menu, well I could use the function but I want it to be "hidden" and just update the cell when the user is finished writing the required number in the other fields.

share|improve this question

1 Answer 1

The functions you're looking for are SLOPE and INTERCEPT, to determine the coefficient of, well, slope and intercept of the fitting line.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.