Function "=SE" with Excel "up" only works in column? but I did not proceed in line

Asked

Viewed 699 times

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"??inserir a descrição da imagem aqui

  • 1

    Try to insert the formula with Ctrl+Shift+Enter. And not only with enter, because it uses matrices.

  • Try it this way: =SE(E(A23=2;B23=2;C23=2);D20)

1 answer

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

You are not signed in. Login or sign up in order to post.