How do I change cell values in a range with a "Yes" formula

To change the values of contiguous cells with a single formula, use matrix formula.

For example, to compare the values of F3, G3 and H3 with 1. If they are equal, return a 1 in cell I3, J3 and K3 as appropriate, do the following:

References

• Create a formula for matrix

To change the values of these cells you have to compare it with another cell.

For example, imagine that in cell A1 you have the value 1, cell B1 will be true or false if A1 is 1.

=SI(A1=1;VERDADERO;FALSO)

B1 will return VERDADERO , if the function is placed in cell B1

You should indicate what you are going to evaluate. Remember the function SI (IF) needs to evaluate an input parameter to return a boolean. You can return what you need (text, number, boolean, etc.)

=SI(CELDA A COMPARAR; VERDADERO; FALSO)

In programming it's the same,

Si (parametro es verdadero) entonces

#código

sino

#código

Fin