I have a sheet I and I want to have the values in one row be set to zero once the corresponding checkbox is clicked. Here is what my sheet looks like(https://postimg.cc/CBDdYsjN), I want each cell in column E to be set to zero when its same row checkbox in col A is set to true.

CodePudding user response：

try in F2:

=INDEX(IF(A2:A=TRUE; 0; E2:E))