Google sheets formula - how to change the value in one cell, depending on the values entered in a row range

Question

In Google Sheets I have a row of values (0 or 1). I want to put a formula in the next column which changes the value in that cell from 1 to 0 if any of the values in the other cells in the same row are equal to 1. What formula would do this?

I have tried IF, SUMIF, COUNT, ARRAY but none of them seem to work and clearly, I am no expert!

Answer 1

You may try:

=byrow(C2:F,lambda(Σ,if(count(Σ),if(sum(Σ)=0,1,0),)))