Login Page - Create Account

Support Board


Date/Time: Thu, 15 May 2025 00:15:48 +0000



Post From: Adding comments to a Study Alert condition

[2021-12-03 00:45:50]
j4ytr4der_ - Posts: 947
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