Hi, all,
I added a new blank row between the N at row 2 and the header at row 5 (now row 6). This naturally changed the formula. So, I've tried to wrap my head around the INDEX formula and finally find myself starting to understand it a bit better.
For N-Day Change, the formula should now read:
If I understand correctly, in this part: $B$2+ROW([@C])-6
the number 6 (prior 5) is simply chosen to make the correct offset and find the correct row/value to reference in the formula. Right?
But what about the number 1 at the end?
$B$2+ROW([@C])-6,1)
*
The formulas for N-Day High/Low were a bit above my capabilities, but I think I've corrected them properly:
Also, on the MINA formula, the last one, I don't quite understand why both [H] and [L] are referenced as opposed to the MAXA where only [H] is referenced.
I consider what I asked solved, but would be great to get confirmation that I got it right and also some explanation on what I'm asking if possible.
EDIT: Although it's strictly solved, I'm unchecking it in case people won't view it if it's "Solved". Will put it back on later. Thanks.
Bookmarks