Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Mon, 03 Nov 2025 12:49:50 +0000

How to Post a Message for Support

Post From: combining conditions help please

[2022-03-06 16:27:39]
[Go To First Post]
Sawtooth - Posts: 4285
If both conditions must be TRUE:
=AND(AND(ID1.SG1>ID1.SG1[-1]>ID1.SG1[-2]>ID1.SG1[-3]>ID1.SG1[-4]),AND(ID1.SG1-ID1.SG1[-1]>ID1.SG1[-1]-ID1.SG1[-2],ID1.SG1[-1]-ID1.SG1[-2]>ID1.SG1[-2]-ID1.SG1[-3],ID1.SG1[-2]-ID1.SG1[-3]>ID1.SG1[-3]-ID1.SG1[-4]))

If either condition is TRUE:
=OR(AND(ID1.SG1>ID1.SG1[-1]>ID1.SG1[-2]>ID1.SG1[-3]>ID1.SG1[-4]),AND(ID1.SG1-ID1.SG1[-1]>ID1.SG1[-1]-ID1.SG1[-2],ID1.SG1[-1]-ID1.SG1[-2]>ID1.SG1[-2]-ID1.SG1[-3],ID1.SG1[-2]-ID1.SG1[-3]>ID1.SG1[-3]-ID1.SG1[-4]))