Support Board

Date/Time: Thu, 25 Apr 2024 19:09:11 +0000

Post From: user2user question regarding excel formula - not a technical SC issue.

[2013-08-13 21:42:35] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3976
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.