Support Board
Date/Time: Tue, 18 Feb 2025 22:31:32 +0000
Post From: Issues with Automated Entry
| [2023-10-27 11:23:56] |
| User907968 - Posts: 831 |
|
=AND(B3>E3,E3=(CZ3+0.1),E3=(DA+0.2)) Assuming that you copied directly from the spreadsheet DA is missing the row number. If that is not the problem, how do you know which of SG1 and SG2 is highest? Is SG1 always the highest, or do you need to test which is the highest? For example: =AND(B3>E3,E3=(MAX(CZ3,DA3)+0.1),E3=(MIN(CZ3,DA3)+0.2)) |