Support Board
Date/Time: Thu, 16 Jan 2025 06:40:41 +0000
Post From: Help with IF statement in SpreadSheet
| [2017-10-12 17:04:52] |
| traderacefly - Posts: 57 |
|
I'm not able to test this but try it and see: =IF(ABS(J8)=0,2,IF($E$3>ID37.SG13@3,1,0)) Checks J8, if position is 0 sets to 2 else sets to 1 if current price is > than ID37.SG13@3. ***You may need to change the last 0 to 2 so that is always defaults to 2. Hope that helps Date Time Of Last Edit: 2017-10-12 17:06:44
|