Formula for Excel - how to make a minus of all values?

Question

excel

The column contains numbers.
How to minus all the lower ones from the first line and display the result in a cell?
I can not find the operator, MINUS is not suitable because I understood it only for two values?

Answer 1

If I understand correctly, and the numbers are arranged in a column each in their own cell, then the formula will be:
\u003d 2 * A1-SUM (A: A)
That is, it subtracts from 2 * A1 the entire sum of numbers from column A. 2 is needed because the fact that the number A1 itself falls into the sum.
This is to avoid stretching the form every time. You can also do this:
=A1-SUM(A2:A100), but if there are more than 100 numbers, you will have to change the formula. So it is better to use the first formula.

Answer 2

alternatively =-ABS(<cell_address>)