Login Page - Create Account

Support Board


Date/Time: Mon, 16 Mar 2026 04:30:20 +0000



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

[2023-08-18 16:43:15]
Sawtooth - Posts: 4316
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.