Q: Reverse percentage formula Apparently "reverse percentage calculations" are a confusing topic (I looked through existing questions) - but I'm not sure I understand it myself.
I have a counter in my Google Sheets that is counting down a certain number of cells, and then I have the total range of cells.
So for example: my counter is at 6000 and its counting down through a range of 7000 cells.
What I'm trying to do is calculate the percentage that it's done counting down.
When I divide the part by the total, I obviously get something like 90% - which is not what I want. It should be like 2% (or whatever) :P
Does anyone know the formula I should apply here?

A: try:
=1-COUNTA(A:A)/A1


(cell formatted as a percentage)



A: I think I solved it.
If A is counting down from 100 and 0 = 100%, then the information I was originally missing was the difference between 100 and A.
So in my case:
A3:
=ROWS(A1:A)-A2
(A1:A is 100%)
(A2 is the current countdown)
So for example if ROWS(A1:A) = 10 (total rows in your sheet) & if my current countdown is 3 then:
A3:
=ROWS(A1:A)-A2 = 7
Then we calculate the percentage by:
A4:
=A3/ROWS(A1:A)
That should give you the correct percentage.
