SLOPE, IF and AND Functions

Hello,

I am trying to calculate the slope of a set of data points, which are within a certain range.

The function I am using is:

=SLOPE(IF(AND(K14:K756>=I5,K14:K756<=I6),K14:K756),IF(AND(K14:K756>=I5,K14:K756<=I6),F14:F756))

Where K14:K756 are the y-values, F14:F576 are the x-values. And then I5 and I6 are the conditions.

Can anyone help me?

Thanks!

I am trying to select the data points between I5 and I6. The data is set up in a way that once I filter out the values I need the x and y values will be on the same row.

This is how I would do this in a simple way. It may be possible to do it without the helper columns by using a more complex formula, but this is easy to understand.

FWIW I prefer XOR LX's solution, just make sure you have an understanding of array formulas.

You are defeating the purpose of the SLOPE formula by being so restrictive on the range. Speaking of purpose, what is the end-goal here. Please provide a small data set and the expected output you hope to achieve (and whatever meaning is to be attached to that output). There just isn't enough supporting information to provide us with what we need to help you.

Hello,

I want to calculate the slope of a stress strain curve. However, the data is inaccurate at the beginning of the test, and it is also hard to tell when the concrete starts acting plastic.
Therefore, I have chosen to work out the slope using the 10% to 40% interval. This is typically done to get a value.

Thanks guys. That last way worked.

Thanks for all the help!