Expected False to change to True if all records are False

[cvh]

I am using the multifield formula to try to change all values in the cells Mon/Tue/Wed/Thu/Fri to True if 'Frequency' is 'Adhoc' and all values in Mon/Tue/Wed/Thu/Fri are False.

However, when I run the formula, the values in the Mon-Fri cells remain False, when they are all False.

The data looks like this before/after running the formula, but after running the formula, they should all be True.

FREQUENCY	MON	TUE	WED	THU	FRI
Adhoc	False	False	False	False	False

Here is my formula:

if [FREQUENCY] = "Adhoc" and
[MON] = 0 and
[TUE] = 0 and
[WED] = 0 and
[THU] = 0 and
[FRI] = 0
then [_CurrentField_] = -1
else [_CurrentField_] = [_CurrentField_]
endif

I selected BOOL fields MON, TUE, WED, THU and FRI as __CurrentField__

Can anyone help answer why the values don't change?

[MarqueeCrew · Accepted solution]

Try this please:

if [FREQUENCY] = "Adhoc" and
[MON] = 0 and
[TUE] = 0 and
[WED] = 0 and
[THU] = 0 and
[FRI] = 0
then -1
else [_CurrentField_]
endif