MS Excel: Calculate Weekly Increase/Decrease

  • Thread starter Thread starter treize
  • Start date Start date
  • Tags Tags
    Excel Function
AI Thread Summary
To calculate a running total in Excel that adjusts weekly based on added or subtracted amounts, users can utilize a simple formula. The process involves creating a formula in a new column that sums the previous total with the new amount. For instance, if the previous total is in one cell and the new amount to add or subtract is in an adjacent cell, the formula would look like this: =previous_total_cell + new_amount_cell. This method allows for continuous updates to the total, reflecting changes in deposits or expenditures throughout the year.
treize
Messages
2
Reaction score
0
Which do I find the excel function for additional amount up every week?

For example: $100 + $50 = $150 last week then add new $50 this week total is $200 to keep the amount up every week. It should work either + /- amount

Thank you.
 
Computer science news on Phys.org
treize said:
Which do I find the excel function for additional amount up every week?

For example: $100 + $50 = $150 last week then add new $50 this week total is $200 to keep the amount up every week. It should work either + /- amount

Thank you.

I'm not completely sure what you are trying to do.
 
Me neither. It sort of sounds like you want a running total, but that's just a matter of adding an equation in the next colum that adds the number above (previous total) to the number to the left (the next new number to add). It's a pretty simple thing.
 
Excel Function

That is correct, the similar like the bank amount sub(-) to spend or sum(+) to deposit...amount keep running total up and down everyday all year. I thought the function can work.

For highlight area sample:
excelsample.jpg
 
Well, the date has now passed, and Windows 10 is no longer supported. Hopefully, the readers of this forum have done one of the many ways this issue can be handled. If not, do a YouTube search and a smorgasbord of solutions will be returned. What I want to mention is that I chose to use a debloated Windows from a debloater. There are many available options, e.g., Chris Titus Utilities (I used a product called Velotic, which also features AI to prevent your computer from overheating etc...
I have been idly browsing what Apple have to offer with their new iPhone17. There is mention of 'Vapour cooling' to deal with the heat generated. Would that be the same sort of idea that was used in 'Heat Pipes' where water evaporated at the processor end and liquid water was returned from the cool end and back along a wick. At the extreme high power end, Vapour Phase Cooling has been used in multi-kW RF transmitters where (pure) water was pumped to the Anode / or alternative Collector and...
Back
Top