Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Sun, 24 Nov 2024 20:49:52 +0000

Need a alternative for =XOR

View Count: 501

[Page 1 of 1] First Page -- 1 -- Last Page

[2023-02-08 05:18:39] #1 [Go To First Post]
User29194 - Posts: 5
"=IF(XOR(AO3=1,AS3=1,AW3=1,BA3=1),1,0)" Returns "#NAME" What alternatives are available to get the same results as above? "=IF(OR(AND(AO3=1,AS3=1,AW3=1,BA=1),AND(AO3=-1,AS3=-1,AW3=-1,BA=-1)),0,1)" works in excel but not in sierra charts. Date Time Of Last Edit: 2023-02-08 13:03:04
0x Thank you

[2023-02-08 15:43:35] #2 [Go To First Post]
John - SC Support - Posts: 36238
If you copied and pasted the second equation, then the issue is that you are missing the row reference for the BA column. See if the following works: =IF(OR(AND(AO3=1,AS3=1,AW3=1,BA3=1),AND(AO3=-1,AS3=-1,AW3=-1,BA3=-1)),0,1) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing
0x Thank you

[2023-02-08 16:49:15] #3 [Go To First Post]
Sawtooth - Posts: 4120
This in excel...: =XOR(AO3=1,AS3=1,AW3=1,BA3=1) ...is this in Sierra Chart spreadsheet studies: =OR(AND(AO3=1,AS3=1,AW3=1),AND(AO3=1,AS3=1,BA3=1),AND(AO3=1,AW3=1,BA3=1),AND(AS3=1,AW3=1,BA3=1),AO3=1,AS3=1,AW3=1,BA3=1) See attached pic.
0x Thank you
XOR function.PNG / V - Attached On 2023-02-08 16:48:51 UTC - Size: 108.69 KB - 90 views

[Page 1 of 1] First Page -- 1 -- Last Page