Support Board
Date/Time: Tue, 26 Nov 2024 20:21:15 +0000
Post From: Issues with Automated Entry
| [2023-10-27 11:23:56] |
| User907968 - Posts: 823 |
|
=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)) |