Combining the SLOPE function with IF function (for filtered slope)

[Robin92]

Hi All,

I am trying to use the slope function to calculate the slope for a range of measurement data (example in table below). While using the Slope function and selecting data by hand everything works perfectly. However, I have to analyse many of these datasets and i don't know exactly which measurement value the upper and lower limit is for the slope. Therefore I would like to connect an IF function that is connected to two cells in which i specify the upper and lower limit (for example 0.5 and 0.3).

I have tried the following :

=SLOPE(IF(AP4:AP243<BC47,AP4:AP243),IF(AP4:AP243<BC47,AO4:AO243))

Here AP contains the measured parameter and AO contains the Temperature. This function returns #value. Would anyone know how to tackle this problem?

Temperature	measured parameter
48.8​	0.577999​
48.9​	0.56894​
49​	0.557452​
49.1​	0.53973​
49.2​	0.517899​
49.2​	0.498636​
49.3​	0.48388​
49.4​	0.464687​
49.5​	0.441245​
49.6​	0.413483​
49.7​	0.383434​
49.7​	0.355835​
49.8​	0.327443​
49.9​	0.297744​
50​	0.263981​
50.1​	0.231059​

 

[Robin92]

I managed using the following equation:

=SLOPE(IF(G4:G244<$BE$71, IF(G4:G244>$BE$72, D4:D244)),IF(G4:G244<$BE$71, IF(G4:G244>$BE$72, G4:G244)))