What Does “–” Mean in Excel

The “–” is a double unary operator. It’s used to change the sign of the value twice.

If you use them for numbers, it doesn’t make a lot of sense, because you will end with the same number that you had before the operation.

This operator is a shorthand method to convert TRUE and FALSE to 1 and 0.

You can use only one minus for FALSE because zero is neither a positive or a negative number.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.