Percentage Used Formula

I'm new so take her easy on me.

I have a column of several cells with 100% at the top,and a % remaining cell at the bottom.
In each cell under the 100% I want to type in the % level and have the % used show in the bottom cell.

100%
-99%

=1% used

I managed to get two cells to do it but cannot find how to get what I need.

Thanks

just put say in a1 100%
then in say a10
=a1-sum(a2:a9)
then if you put 90% in a2, a10 will say 10%
if you are using -90% use
=a1+sum(a2:a9)

Well, not quite. I inputted your suggestion and it failed.

I am charting a battery. My column starts at 100% When I type in the cell under it the remaining charge of 89% it will show 11% used. Good!
Now I say use 5 more % and type in 83% remaining the used total shows -72% when it should show 17% used. 100 - 83 = 17.

This is the wall I have been hitting.

Yes but in a standing column like the one attached.

so the 90% is what's left and you want to know the amount used in c36?
so c26 =c5-min(c6:c25)

Thanks but I get errors. To clarify I have attached another you may want to play with?

You formula had some type -o's perhaps?

C5 is the starting value @ 100%
C36 is where the remaining % should display.

So as values are entered I want the remaining % to be calculated.

And to demo how green I am, I take it the formula is to be inserted in the C36 cell?

On one try I got a warning about circular formulas.

Thanks, Hang in here guys I need this.

you are not being clear, what is the value in c7? is its whats used or whats left?
in c36 =c5-min(c6:c35) will give 14% ie thats what has been used if 86% is left
what answer from your example should be in c26?

Thanks, For Your Patience,

Ok, The % values entered by me are what is left as reported by the device.
We may be seeing different row numbers on our PC's.
You say C26? Do you mean C36? My C36 is the bottom cell in the "Totaled" row.

My 100% is in C5, then 90% in C6 and 86% in C5, the totaled cell is C36 on my PC.

As I enter a new value below the previous one I want the sheet to subtract only that number from 100% and put the total in the bottom cell C36.

So I guess you would say it ignores the previous values calculating only using the most recent entry?

Thanks!

yep so
as i said
in c36 =c5-min(c6:c35)

Originally Posted by martindwilson

yep so
as i said
in c36 =c5-min(c6:c35)

THANKS. Ole greenhorn here included the c36 before your = sign in your instructions. Heh!

Last, I get error splats in two cells (I have four columns) but they work perfect!

Thanks!