excel or 取取反

In Excel, you can use the "NOT" function to get the logical opposite of a value. For example, if you have a value in cell A1 and you want to get its logical opposite, you can use the formula "=NOT(A1)". This will return "TRUE" if the value in A1 is FALSE, and "FALSE" if the value in A1 is TRUE.

Alternatively, if you want to get the numerical opposite of a value (i.e., the negative value), you can simply use the negative sign ("-") in front of the cell reference or value. For example, if you have a value in cell A1 and you want to get its negative, you can use the formula "=-A1". This will return the negative value of A1