Support Board
Date/Time: Sun, 22 Dec 2024 16:04:48 +0000
Post From: help with spreadsheet formula
| [2015-02-10 08:44:37] |
| jivetrader - Posts: 410 |
|
i ended up doing nested IFs kind of like this =IF(AND($K3=TRUE,$K4=FALSE),$E4,IF(AND($K3=TRUE,T3>T4),$E3,IF($K3=TRUE,V4,0))) if we are at a crossover point (current row 3 is true and last row 4 was false) then E4 (previous LAST price). furthermore if current row is true (and last row was also true, because it wasn't false, right?) and indicator in column T is increasing, then E3 (current last price). if however current row is still true but the indicator isn't increasing, just give me the previous value in this column (V4). else (i.e. if current row is false) give me zero. a little crazy but working well. Date Time Of Last Edit: 2015-02-10 08:45:39
|