slope

[dmheller]

I am having trouble with a slope equation.
=slope(if(Q7:1506>1,Q7:Q1506),if(And(F7:F1506>Y1480,F7:F1506<Y1481),F7:F1506))
ctrl+Shift+entr
Column Q is a bunch of data numbers only
Column F is dates
Column Y are the 2 dates I am looking between
I want to get the slop of the data between the dates but only for data numbers greater than 1.
An help would be great.

 

[joeu2004]

I think your formula got mangled by this forum's GUI. Always put spaces around " > " and " < " (although I think only one of them is a problem).

We cannot use AND(), OR() etc in array-entered formulas because those functions take array paremeters themselves.

Try something like the following, array-entered. Pay close attention to whether you want " > " and " < " or " >= " and " <= ".

=SLOPE(IF(Q7:Q1506 > 1, Q7:Q1506),
IF(Q7:Q1506 > 1, IF(F7:F1506 > Y1480, IF(F7:F1506 < Y1481, P7:P1506) ) ) )

 

[joeu2004]

Disregard the SLOPE formula in my previous response. I was so focused on the replacing the use of AND() that I overlooked the flaw in your logic in the first parameter. The conditions for selecting "y" and "x" data must be the same, to wit:

=IFERROR(SLOPE(IF(Q7:Q1506 > 1, IF(F7:F1506 > Y1480, IF(F7:F1506 < Y1481, Q7:Q1506) ) ),
IF(Q7:Q1506 > 1, IF(F7:F1506 > Y1480, IF(F7:F1506 < Y1481, P7:P1506) ) ) ) , "")

I added an IFERROR wrapper, just in case less than 2 rows of data meet all of the conditions.