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 :
Here AP contains the measured parameter and AO contains the Temperature. This function returns #value. Would anyone know how to tackle this problem?
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 :
Excel Formula:
=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 |
Last edited by a moderator: