Answer the question
In order to leave comments, you need to log in
How to apply percentage formula to other cells?
There are 2 columns, in one the sum of all values, and in the other the percentage of the number from the first column from the sum of the values.
Example table
I want to apply the formula from the second column =A2/A1
to other cells, but the system does not apply it correctly. Instead, it replaces the cell number of the denominator with the digit of the cell to which the formula is applied. It turns out something like this.
And it is necessary that it be so
How to fix it?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question