Support Board
Date/Time: Sat, 23 Nov 2024 22:18:21 +0000
Post From: user2user question regarding excel formula - not a technical SC issue.
| [2013-08-13 21:42:35] |
| Sawtooth - Posts: 4118 |
|
There is an easy way to show only the first arrow until there is an arrow in the opposite direction. Example for an up arrow: Put this in P3: =IF(E3>AA3,TRUE,IF(E3<AA3,FALSE,P4)) This will stay TRUE until E3<AA3. Put this in Q3: =IF(AND(P3,P4=FALSE),D3,0) This will place a Draw Style object at the low of the bar, but only when P3 changes from FALSE to TRUE. You can modify P3 to meet your needs. |