Login Page - Create Account

Support Board


Date/Time: Sun, 24 Nov 2024 20:47:15 +0000



Post From: Need a alternative for =XOR

[2023-02-08 05:18:39]
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