Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 12:33:34 +0000



Post From: Are successive >'s limited to 3 in spreadsheet studies?

[2023-08-18 16:43:15]
Sawtooth - Posts: 4120
This works:
=AND(ID2.SG1@3>ID2.SG2@3>ID2.SG3@3,ID3.SG1@3>ID3.SG2@3>ID3.SG3@3)
but this doesn't:
=AND(Q3>R3>S3>T3>U3>V3)

The latter is truncated to this:
=AND(Q3>R3>S3)

Please advise.