Thank you, this is pointing me in the right direction. In column C I have a slope formula. In column D I have a high point formula and in column E I have a low point formula.
=SLOPE(B2:B3,A2:A3)
=IF(AND(C3>0,C4<0),B3,"")
=IF(AND(C3<0,C4>0),B3,"")
Thank you, this is pointing me in the right direction. In column C I have a slope formula. In column D I have a high point formula and in column E I have a low point formula.
=SLOPE(B2:B3,A2:A3)
=IF(AND(C3>0,C4<0),B3,"")
=IF(AND(C3<0,C4>0),B3,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks