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"??
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