Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 08:29:57 +0000



Post From: Adding comments to a Study Alert condition

[2021-12-03 00:45:50]
j4ytr4der_ - Posts: 938
And no sooner do I post this, than I encounter a place where adding it has broken the formula. Can't really see why it has worked for me up to this point and now does not here. Anyway, in case it's helpful... there it is.

EDIT: Ah of course, it needs to go inside an AND block, like so:

=IF(REM="Name of my code block","",IF(
AND(
IF(REM="Some formula description","",""),
ID0.SG2@3 - ID0.SG3@3 >= J21,
IF(REM="Another formula description","",""),
ID102.SG1@3 = 0,
IF(REM="And yet another...","",""),
ID102.SG3@3 > ID102.SG2@3,
),
ID0.SG2@3,
0
))

Date Time Of Last Edit: 2021-12-03 01:00:10