Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Thu, 23 May 2024 06:41:55 +0000
Post From: If Condition is met, then enter position if other condition is met
| [2018-04-29 23:33:16] |
| Sawtooth - Posts: 4003 |
|
Try this: In a spare Formula Column, e.g., P3, create a persistent variable: =IF(AND(AH3>AF3,AL3>AJ3,D3<=AC3),1,IF(AND(AH3<AF3,AL3<AJ3,D3>=AC3),0,P4)) (You can use any viable condition to clear the persistent variable. In the above example, I reversed the operators.) Then in K3: =AND(CROSSFROMBELOW(AN3:AN4,AO3:AO4),P3) (You don't need to reference J8=0 if 'Allow Multiple Entries In Same Direction' is set to No.) Here are more formula examples of persistent variables: Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables Date Time Of Last Edit: 2018-04-30 13:40:22
|