Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Sean
Sean asked in Computers & InternetSoftware · 4 years ago

Microsoft Excel: Creating a sum function that can be updated.?

Hi, I'm trying to locate an addition function within excel that will allow me to update my balance. Okay here is an example.

I have

Income: +1000

Expenses: -250

Total: 750

Pretty simple, but I'm looking for a function which will allow me to reset that without having to faff around. So every time I click, say F12 for example, another 250 will be taken from the 750 until it becomes -250, -500 and so on and so forth.

Thanks!

3 Answers

Relevance
  • Undisclosed
    Lv 5
    4 years ago

    This sort of thing is what VBA is for. It's a lite version of Visual Basic that is used by MS Office.

  • Bill
    Lv 7
    4 years ago

    You can have a cell with a formula like =sum(b2:b10), put the -250 in b2, and then paste it to b3, b4, etc. If necessary you can insert more rows.

  • Sean
    4 years ago

    Thanks, it's just understanding how to make macros now haha!

Still have questions? Get your answers by asking now.