Excel question

There’s quite a good discussion of these sorts of precendence issues in this thread from late last year:

Along about post 94 it switches gears to the various forms of confusion available between monadic negation, dyadic subtraction, and the leading negative specifier of a digit string all using the “-” symbol for what are actually different ideas.

that portion, from post 94 to the end, bears directly on the OP.