1
In a small table, I inserted the function "=If" with the ":", but it only works if I put the numbers with their respective colored spheres in column, when I specify what I want from the cells =se(A23:C23=2;$D$20) the result is not "waiting"but when I place in columns the cells "A23" until "C23" the result comes out correct (waiting), as I do to specify in line the cells "A23" until "C23"??
1
If by =SE(A23:C23=2;$D$20) you mean to say: check if all values are equal to 2. So, this will always be invalid, unless the sequence is in the same column and it will still only check whether the A23 is equal to 2, ignoring all other values. A correct formula for this would be =SE(CONT.SE(A23:C23;2)=CONT.VALORES(A23:C23);$D$20)
Browser other questions tagged excel
You are not signed in. Login or sign up in order to post.
Try to insert the formula with Ctrl+Shift+Enter. And not only with enter, because it uses matrices.
– danieltakeshi
Try it this way:
=SE(E(A23=2;B23=2;C23=2);D20)– R.Galamba