I have written simple code that plots points that are lows in a series of data
( Stock Market data ). Basically the code is
=IF(AND(B6<B5,B6<B7),B6,NA())
which in a column prints out a low, otherwise prints #N/A
What I would like to do is further analyze this column
( column F in the attached example ) but am unsure if the coding technique.
For example, would like to calculate the differnce between the individual lows
and the value of the difference of the lows.
I apologize for the low excel skill level.
Bookmarks